Can anyone help me with a formula that will count the following conditions in a summary formula

Best Answer

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Answer ✓

    @Tom Lindsay

    I am not exactly sure what your asking. Are you wanting to count how many different selections there are? If so then do =Countm(Row@row). If your asking how to do a countifs depending on the selections. Then you want =Countifs(Contains("Text",@cell),followed by the rest of your formula. With out more information on what it is exactly your trying to do I cant give much more info then that.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Answers

  • Tom Lindsay
    Tom Lindsay ✭

    · Share on FacebookShare on Twitter
  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Answer ✓

    @Tom Lindsay

    I am not exactly sure what your asking. Are you wanting to count how many different selections there are? If so then do =Countm(Row@row). If your asking how to do a countifs depending on the selections. Then you want =Countifs(Contains("Text",@cell),followed by the rest of your formula. With out more information on what it is exactly your trying to do I cant give much more info then that.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!