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.


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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try this...

    =IF(CONTAINS("High", [Column Name]1:[Column Name]5), "High", IF(COUNTIFS([Column Name]1:[Column Name]5, "Low") > COUNTIFS([Column Name]1:[Column Name]5, "Medium"), "Low", "Medium"))

    Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!

    If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.

  • Denise Drinkard
    Answer ✓

    THANK YOU!!!....been racking my head on that one. works perfect


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!