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)
[By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!](https://bensomething.notion.site/By-Ben-Latest-Was-this-helpful-Please-consider-buying-me-a-coffee-Cheers-7e0a08e8adbe4fc8af49603e9622621a)