Help with populating one column based on value of range of columns

I have a number of columns with either "High", "Medium" or "Low" as the value and am wanting to return either "Yes", "No" or "Maybe" in another column based a result in any of those columns.

So if any of columns A - E contains "High" then column F should show "Yes"

Thanks in advance for any help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!