How to automatically assign a Symbol when comparing two date columns?
This is what I got.
=IF([Launch Date]@row >= [Estimated Delivery Date]@row, "Green", IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red"))
However, I want "Yellow" to be assigned when the [Estimated Delivery Date] is less than 30 days from the [Launch Date].
Appreciate the insight.
Answers
-
Hi @Roberto Sanchez
Hope you are fine, please try the following formula:
=IF(OR([Estimated Delivery Date]@row = "", [Launch Date]@row = ""), "", IF([Launch Date]@row - [Estimated Delivery Date]@row >= 30, "Green", IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red", IF([Launch Date]@row - [Estimated Delivery Date]@row < 30, "Yellow"))))
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you so much. Worked as intended on my end.
-
Excellent, I will be happy to help you any time. Please help the Community by marking it as an accepted answers
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!