How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail".
=IF([QA Filter FAIL]@row = "Fail", "Fail", (IF(AND([Code QA]@row = "Pass", Format@row = "Pass", OR([Internal Dashboard QA]@row = "Pass", [Internal Dashboard QA]@row = "N/A"), OR([Cross Dashboard QA]@row = "Pass", [Cross Dashboard QA]@row = "N/A")), "Pass", "")))
Based on what is in this column (QA Filter), I set up this automation. (There is two of them, one for a pass which is shown below and one for fail)
The automation doesn't seem to be working and I think it is because there is an if statement in the column. When I just type in Pass in the column the automation works as expected. Is there a way around this?
Answers
-
Hi
Having a formula change the QA Filter value should not impact the automation. Both the formula and automation look good to me. One thing, you could try is to change the trigger to be when a new row is added or changed.
When you are manually typing "pass" the row exists and you are overtyping it. When you have the formula complete this value, it might be the first time data has been entered in the row, so will not trigger. Worth a quick try, I hope.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.1K Ideas & Feature Requests
- 87 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!