"Live Date" is 4 weeks from "Submitted Date"

Hi,

I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.)

I know I need a helper column, and I know how to do greater than, less than, equal to with an =IF statement, but how do I set the formula to account for the 4 weeks I want between "Live Date" and "Submitted"?

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

raltamirano

Hi!

Could you do =if([Live Date]@row=[Submitted Date]@row+28, "True","False)?

The 28 would account for the 4 weeks (4*7=28)!

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.