Date comparison, if greater than 30 then flag

Hello,

I have two date columns that I would like to compare. The first column is named Requested and the second column is named [Sign off on]. In a third column formatted for symbols is where I've written the following formula,

=IF([SIGN OFF ON]@row + 45 > REQUESTED@row, 1)

I would like to get a flag if the [sign off on] column is 45 days greater than the requested column.

The problem is that it is flagging everything. Any suggestions?

Thanks,

Mily Oti

Find more posts tagged with

Accepted answers

Mily Oti

Figured it out. The +45 needs to be with the Requested.

All comments

Mark Cronk

=IF([SIGN OFF ON]@row + 45 > REQUESTED@row, 1,0)

Mily Oti

Hi Mark,

Thanks for your reply. I added the 0 but it still flags every single row, even when there's only a day difference between the two.

If you can think of anything else, I would appreciate it.

Mily

Mily Oti

Figured it out. The +45 needs to be with the Requested.

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.