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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!