Formula Question
clifka
✭✭✭
Hi There.
I have a sheet, very much like a project tracking sheet, with a few adjustments. I have a start date / due date / completion date, as well as a status column. I would like to create a column that has green/yellow/red dot based on the status being not started or in progress AND relative to the due date.
We have the formula that works for time based on due date; however, can I add another statement to include the status OR if the completed date isn't filled in, then it shows it?
Thanks for looking at this(screenshot attached) and providing any assistance.
Tags:
Comments
-
Hello,
You can add this to your formula to get the word "blank" to show in the RYG column:
IF([Start Date]7 = " ", "blank"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!