Flag Formula

Jlaustse

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)

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?

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!