Status Ball formula 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!
Best 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")))
Answers
-
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")))
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!