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.

MichelleMWatkins

Hello,

You can add this to your formula to get the word "blank" to show in the RYG column:

IF([Start Date]7 = " ", "blank"