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


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!