IF Formula to assign a symbol depending on where a date is in relation to today's date.
Hi, I'm looking for a formula to indicate where a specific date in one column is in relation to today's date. I have the column where this formula will be input setup as a symbol column to return a color (Red, Yellow, or Green) to indicate the relation between today's date and the date in another column.
If the date is in the past or in the next 9 months, "red". If the date is in the next 9-15 months, "yelllow", else "green".
Thank you!
Answers
-
Update, I have figured this out! Here's the formula I used:
=IF([Expiration]@row < TODAY(), "Red", IF([Expiration]@row - 270 <= TODAY(), "Red", IF([Expiration]@row - 450 <= TODAY(), "Yellow", "Green")))
Happy for feedback if there is a better way, but this is working!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!