Help with Status driven by date columns

Mike Norman

Hello, I am trying to automate my status column that is driven by dates.

Date columns: Deployment Start, Deployment End, Planning Start, Planning End

Statuses: Planning (this is default) status; Execution, Complete

I'd like the status to default with Planning if dates are blank or within the Planning Start & End, Execution status for when between Deployment Start and End, and Complete when date is after Deployment End.

Any thoughts?

Mark Cronk

Hi @mgn2683 ,

You would just change the Column references to your Deployment columns as long as you wanted the same logic and text returned:

=IF(OR(ISBLANK([Deployment Start]@row), ISBLANK([Deployment End]@row)), "Deploying", IF(AND([Deployment Start]@row,<=Today(), [Deployment End]>=Today()), "Execution", "Complete"))

Does that work for you? Happy to help.

Mark

Mark Cronk

Hi @mgn2683 ,

Suggested formula is below. Status Formula:

=IF(OR(ISBLANK([Planning Start]@row), ISBLANK([Planning End]@row)), "Planning", IF(AND([Planning Start]@row,<=Today(), [Planning End]>=Today()), "Execution", "Complete"))

Work?

Mark

Mike Norman

Hey Mark, how would I include the second set of date columns - Deployment Start & Deployment End?

Basically, "Planning" stage would only be during the Planning Start & Planning End dates, Execution & Completion would change based upon the Deployment Start & Deployment End dates.

Mark Cronk

Hi @mgn2683 ,

You would just change the Column references to your Deployment columns as long as you wanted the same logic and text returned:

=IF(OR(ISBLANK([Deployment Start]@row), ISBLANK([Deployment End]@row)), "Deploying", IF(AND([Deployment Start]@row,<=Today(), [Deployment End]>=Today()), "Execution", "Complete"))

Does that work for you? Happy to help.

Mark