Trying to use flag column...if date is within 3 days = flag, if not, or blank = no action. Below is the formula that is not working. What am I doing wrong?
=IF (ISBLANK([Submit by]@row)), 0, =IF([Submit by]@row <= TODAY(+3)), 1
Thanks!
Hey @Becky Greenbury
The parentheses in the formula are closing off too soon and not allowing the formula to execute.
Try this
=IF(ISDATE([Submit by]@row), IF([Submit by]@row <= TODAY(3), 1))
Is it ok that the flag stays lit if the [Submit by] was yesterday, or last week, or last year, etc? The formula says ON if it's TODAY+3 or less.
If you wanted the flag to only be on for Today up to Today(3) then use this formula instead
=IF(ISDATE([Submit by]@row), IF(AND([Submit by]@row <= TODAY(3), [Submit by]@row > TODAY(-1)), 1))
cheers,
Perfect, that did it. Thank you so much!
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.
