Help with Status driven by date columns

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?

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.