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!
Help Article Resources
Check out the Formula Handbook template!