formula for status column using symbols based on end and target dates
Hello,
I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like:
If end date is not past target date then status is green
If end date is past target date then status is red
Could someone help with the formula?
Thank you in advance!
Best Answer
-
Do you want it based on the current date, or is there a "task due today" column?
If there is a task due today column:
=IF([target date]@row > [task due today]@row, "Green", "Red")
If it is based on the current day:
=IF(TODAY() < [target date]@row, "Green", "Red")
Answers
-
Do you want it based on the current date, or is there a "task due today" column?
If there is a task due today column:
=IF([target date]@row > [task due today]@row, "Green", "Red")
If it is based on the current day:
=IF(TODAY() < [target date]@row, "Green", "Red")
-
This worked! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 214 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 456 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!