# Status Ball formula question

Options

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!

• Employee
Options

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")))

• Employee
Options

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")))

• Options

Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!