Using "If" with dates

Hi all,

I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.).

I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100% confident that I'm missing some bits there.

Here's a screenshot of some of my data (ignore the "health" column). I want "Start Date" to be compared to today's date and generate a status in the "Test Status" column (not started, in progress, overdue).

Thanks much for all of your help and suggestions!

Find more posts tagged with

Formulas

Accepted answers

All comments

A. Rose

You can do both in Workflows, Create 1 workflow record a date, and another Workflow change type,

Let me know if you need more details,

Thanks,

Paul Newcome

You are going to want to start with something like this:

=IF([Start Date]@row > TODAY(), "Not Started", IF([End Date]@row > TODAY(), "In Progress", "Overdue"))

Susan L.

Thanks Paul-would it look like this:

=IF([Start Date]@row > TODAY(), "Not Started", IF([End Date]@row > TODAY(), "In Progress", IF([End Date]@row >TODAY (), "Overdue")))

With thanks!

Paul Newcome

You should be able to use the formula I provided above. If you did want to specify criteria for "Overdue", then you are going to want to change that argument from greater than to less than.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.