How can I add days to a date field within a logic formula to output a true/false value for a chkbox?

My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow.

The logic criteria is as follows:

"Overall Status" = Blue (complete)….and….
"Working Launch" Date + 7 Days </= Today's date

So, if a project is complete, and the launch date plus 7 days is a date in the past, the box will be checked.

Note, the Working Launch column is a Date field and restrict to date is turned on.

Thanks!

Find more posts tagged with

Formulas

Support

logic

dates

Accepted answers

All comments

Darla Brown

Hi,

Try this:

=IF(AND([Overall Status]@row = "Blue", [Working Launch]@row <= TODAY()), 1, 0)

sblackmarr

Thank you @Darla Brown! This formula works well. I didn't realize I could add a "-7" to the TODAY () expression to give me the delay I was looking for. Research on the TODAY function revealed that answer. Appreciate your help!

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.