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
-
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
-
Lets try cleaning up some parenthesis first...
=IF(AND(TODAY(-14) > [Date Submission Review Complete]@row,[Invoice Attached]@row = 0, ISBLANK([ETR Attached]@row), [Receipt Attached]@row = 0), 1)
-
It will check the box if they all are not done, but I want it to check the box even if one is not done.
In my screen shot for row one, you can see that the ETR Column is blank but the Attachment Complete box that I am using for my automation is not checked.
I feel like I need some type of OR statement?
-
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)
-
Thank you for your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!