Formula for changing symbol colors
I created a column that changes symbol colors depending on the start date column. The below formula I put together after reading through some other posts within this community works alright except for the bit to have the symbol change to gray when the start date is today or past. What am I missing?
=IF([Start Date (ET)]@row < TODAY(14), "Red", IF([Start Date (ET)]@row < TODAY(21), "Yellow",IF([Start Date (ET)]@row <= TODAY(), "Gray", "Green")))
Answers
-
Hi @Amwil, your condition "<TODAY(14)" will always be met before your condition "<=TODAY()". Rearrange to put the gray at the start. Always check the order of your criteria -- the first "IF" that meets it's criteria will trigger first.
=IF([Start Date (ET)]@row <= TODAY(), "Gray", IF([Start Date (ET)]@row < TODAY(14), "Red", IF([Start Date (ET)]@row < TODAY(21), "Yellow", "Green")))
-
@Lucas Rayala noted, thank you for the assistance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!