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
if()
if(and(not empty("Shift Length"), prop("Bonus")), if(prop("Shift Length") == "Half", 30, 60), 0)
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>