I am trying to narrow my conditional formatting for an order dependent on 2 different parts---

I created 2 condition columns for a line item, First Condition Column "Y/N" and Second Condition Column "Y/N"

...and in a third column "Required" I simply want and IF/ AND formula to say IF First Condition Column is "Yes" and IF Second Condition Column is "Yes" at the row---THEN the Required Column will be "Yes" at the row ----IF either First or Second are "No" or both are "No" THEN the Required Column would indicate "No"

=IF(AND([First Condition]@row "Yes", [Second Condition]@row "Yes", "Yes", "No")

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!