Smartsheet at- risk formula


Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column.

I only want the column to flag is the status is not complete and the target end date is past due. My current formula is =IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0)

Currently, the column flags even when the target end date is blank. I only want the flag when the status is not complete, and the target end date is past due, AND the target end date is not blank.

Please help!


Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Try somethingn like this...

    =IF([Target End Date]301 <> "", IF(AND(Status301 <> "Complete", [Target End Date]301 <= TODAY()), 1, 0))

    This will take your original formula and run it only if the [Target End Date] is not blank.


Sign In or Register to comment.