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

Options

Best Answer

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

    @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.

Answers

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

    @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!