ISBLANK AND formula issue

KIMST

Hi Community:
If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific individual.

Column A: Intention for IF this column is BLANK (fyi Properties of this column is dropdown list)
AND
Column B has properties of a created date entry from a form. And I would like Column C to Flag IF Column B is >= 5 days or more since the task has been assigned.

Current formula in use, continues to throw errors:
=IF(AND(ISBLANK([Coder Assigned to Review Claim]@row), TODAY() >= (INT([Date of Submission]@row) + 5)), "Condition Not Met", "Condition Met")

Have tested (Screenshot below) Column A ISBLANK([Coder Assigned to Review Claim]@row and Column C flagged appropriately. But when I add Column B (Date of Submission) I continue to get error codes
Thank you!

jmyzk_cloudsmart_jp

Hi @KIMST

My Date of Submission has date values, not Created system value.

So, there may be a time zone issue, but overall, the following formula should work.

=IF(AND(ISBLANK([Coder Assigned to Review Claim]@row), [Date of Submission]@row - TODAY() <= -5), true)

https://app.smartsheet.com/b/publish?EQBCT=d9f5765cec894f608ffd6555878052d8

jmyzk_cloudsmart_jp

Hi @KIMST

My Date of Submission has date values, not Created system value.

So, there may be a time zone issue, but overall, the following formula should work.

=IF(AND(ISBLANK([Coder Assigned to Review Claim]@row), [Date of Submission]@row - TODAY() <= -5), true)

https://app.smartsheet.com/b/publish?EQBCT=d9f5765cec894f608ffd6555878052d8

KIMST

Thank you for finding the 2 errors! You've just made a Friday more easy!

jmyzk_cloudsmart_jp

Happy to help！😏