Revise Formula to include a but

My current formula in one column that is working out is the below:

=IF(OR(CONTAINS("Term", [Column1]@row), [Column2]@row = 1), "Green", "Yellow")

For the next column I need a revised formula to say "if the term is in column 1 and column 2 is check BUT Column 3 is checked then it will give me a red ball"

What do I need to add to my formula?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!