Formula to update a value automatically

I have 5 rows. The value for each can be low, medium, or high.

If the majority of the rows is one of the values then I want row 6 to return that value. But if any of the rows are high Row 6 value should be high.


Example:

Row1--Medium, Row2--High, Row3--Medium, Row4--Low, Row5--Low., Since Row2 is High Row 6 value is High

If Row2 value was Medium, then Row6 value would be Medium.


any idea on a formula to do this automatically?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!