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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 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!