due date changing the status?
Hello guys,
I'm working on my project plan sheet and i'm facing some difficulties formatting the columns,
How to change the Status based on due date (if the today's date pass the due date, the status column changed to something else *red (delayed)* for example)
Here are the down list of columns:
Status: Started, on hold, completed, delayed, not started
and the dates columns: Start date, end date, due date
Thanksss!!
Answers
-
Hey @Yazeed Alsaleh
You can accomplish this using a nested IF statement. Here is one recent example https://community.smartsheet.com/discussion/comment/309966
If you provide the conditions of the colors to the community, we can help you build the formula.
cheers,
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 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!