Status Ball formula question

Question

I'd like to create a formula to automatically change the color of the status ball but I've never created an IF statement and could use some help please.

If equal to or less than Meeting Start date, then yellow

If equal to or between Meeting Start date and meeting end date, then green

If equal to or after Finalize Budget, then red

thanks!

Chris Ho · Accepted Answer

This formula assumes that meeting end is always after meeting start. Here is a similar thread to your question in case you want to know more about formulas: https://community.smartsheet.com/discussion/18476/if-then-else-logical-function

=IF(TODAY() <= [Meeting start]@row, "Yellow", IF(TODAY() <= [Meeting end]@row, "Green", IF(TODAY() >= [Finalize budget]@row, "Red")))