Formulas for flags

Jlaustse

I need some help with formulas - cell names are in brackets.

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

If [Credentialing Initiated HRSS] has a date, AND [App Completed in Portal by Provider/CVS] is blank after 7 days, flag

Rainier Hollands

Hi @Jlaustse

If either one of those two if statements are true, must it display the same thing, or are they two different statements?

If they the same you can use:

If(or(and(

otherwise

if(and(...),X,if(and(...))

Hope this makes sense

Rainier

Jlaustse

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

Jlaustse

@Rainier Hollands These are for two different formulas.

Rainier Hollands

@Jlaustse

The today part of your formula is always going to take your desktop date, so if you want to see whether it's going to blank in 7 days, you will never get an answer. I hope that makes sense?

I would personally create a date column and then just say

if(isblank(vlookup((date)+7), your range, Credentialing Initiated HRSS,False),1,0)

Paul Newcome

Try something like this...

=IF(OR(AND(ISDATE([HRSS Sends Request for Personal Info]@row), [HRSS Sends Request for Personal Info]@row + 7 < TODAY(), ISBLANK([Credentialing Initiated HRSS]@row)), AND(ISDATE([Credentialing Initiated HRSS]@row), [Credentialing Initiated HRSS]@row + 7 < TODAY(), ISBLANK([App Completed in Portal by Provider/CVS]@row))), 1)