Flag Formula

My formula for the below isn't flagging correctly. Can someone take a look at it?

Intended action:

If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag

Formula:

=IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated HRSS]@row - TODAY() > 7)), 1, 0)

Find more posts tagged with

Accepted answers

Andrée Starå

Apologies, forgot to change it.

Here you go.

=IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated HRSS]@row), [HRSS Sends Request for Personal Info]@row <= TODAY(-7)), 1)

Did that work?

All comments

Andrée Starå

Hi ,

There seems to be one part missing?

=IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated HRSS]@row), ??? - TODAY() > 7)), 1, 0)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jlaustse

Andree,

I don't know what to put in the missing part -- I need it to do: If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag

Andrée Starå

Ok.

Do you have a date added to check against or do you want to use the System Column, Created?

Jlaustse

I need it to flag if the [Credentialing Initiated HRSS] is still blank after the [HRSS Sends Request for Personal Info] date.

Andrée Starå

Ok.

Try something like this.

=IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated HRSS]@row), [HRSS Sends Request for Personal Info]@row >= TODAY()), 1)

Did it work?

Jlaustse

Hmm that's missing the 7 days part.

If [HRSS Sends Request for Personal Info] has a date, AND [Credentialing Initiated HRSS] is blank after 7 days, flag

Andrée Starå

Apologies, forgot to change it.

Here you go.

=IF(AND(ISDATE([HRSS Sends Request for Personal Info]@row), ISBLANK([Credentialing Initiated HRSS]@row), [HRSS Sends Request for Personal Info]@row <= TODAY(-7)), 1)

Did that work?

Jlaustse

This worked. You are AMAZING thank you so much!!

Andrée Starå

Excellent!

You're more than welcome!

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.