Ben SmithBen Smith
Ben Smith/
Bonus Amount
Bonus Amount
Bonus Amount

Bonus Amount

For
vjethro23
From
Reddit
Status
Updating
Formulas
==
==
if
if
Share
Work

Bonus Amount

and(not empty(prop("Shift Length")), prop("Bonus")) ? ((prop("Shift Length") == "Half") ? 30 : 60) : 0
and(not empty(prop("Shift Length")), prop("Bonus"))
Checks to see if Shift Length is not empty and Bonus is checked.
? ((prop("Shift Length") == "Half") ? 30 : 60)
If they are and Shift Length is Half, display 30, otherwise display 60
: 0
Otherwise if Shift Length is empty or Bonus is unchecked, display 0

Bonus: if()

if(and(not empty("Shift Length"), prop("Bonus")), if(prop("Shift Length") == "Half", 30, 60), 0)
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!