Formula for Changing Symbols
I am trying to create a formula where the symbols (red, yellow and green circles) change when red when it is passed the Extension Deadline date, yellow when it is 60 days from the date, and green when it is more than 60 days from the date. What is a formula I can use to achieve this?
As of right now this is the formula I have: =IF([Extension Submittal Deadline]@row < 60, "Red", IF(AND([Extension Submittal Deadline]@row > 60, [Extension Submittal Deadline]@row = 60), "Yellow", [Extension Submittal Deadline]@row > 60, "Green"))
But it only shows red for all the other rows under 60 day notice.
Answers
-
In your current formula you are comparing the value 60 with the value of the date, which makes no sense: You will have to use the TODAY function in combination with your date column:
... [Extension Submittal Deadline]@row - TODAY() < 60 ... if you want to compare today's date with the specified date and see if it has passed 60 days from now.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!