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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!