How to set up an automation that is based on an if statement?

gestep

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?

KPH

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.