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.
Help Article Resources
Check out the Formula Handbook template!