Hello,

Attached I have an example of what i would like to have. What i need to do is have a formula in the "final status" column that will automatically update. There are three outcomes for the final status either, "complete", "underway", or "not started". The formula would need to pull off of only the columns that are highlighted in blue. In these columns there will only be dates. When there is a date that means that part of the process is done.

For the final status to be complete, all of the columns highlighted blue need to have a date.
For the final status to be underway, there needs to be at least one date in the columns highlighted in blue.
For the final satus to be not started, there should be no dates in the columns highlighted in blue.

For this formula, the other columns in white do not matter, just looking to see if the process is complete.

Thanks for the help.RSML.xlsx