Formula Question

clifka ✭✭✭
edited 12/09/19 in Formulas and Functions

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.

Smartsheet_tracker screenshot.docx_.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!