Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • Community Champion

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions