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?
Help Article Resources
Check out the Formula Handbook template!