Automation with a check box

I am trying to set-up an automation using a check box. I want a box to check so I can alert a program manager:

IF it is later than 14 days from the Date Submission Review Complete and the Invoice is not Attached (this is a check box), the ETR is not attached (this is a drop down selection so I was trying to say if it was blank, and the Receipt is not attached (this is a check box).

But I am getting an error and I am not sure my logic is correct. If after 14 days all of these columns should be completed with a selection or check.

=IF(AND(TODAY(-14) > [Date Submission Review Complete]@row,([Invoice Attached]@row = 0, ISBLANK([ETR Attached]@row), [Receipt Attached]@row = 0), 1))

Thanks for your help!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Now that we have the error taken care of, we can work on the logic. How does this work for you?

    =IF(AND(TODAY(-14) > [Date Submission Review Complete]@row,OR([Invoice Attached]@row = 0, ISBLANK([ETR Attached]@row), [Receipt Attached]@row = 0)), 1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!