Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Formula assistance - multi select column and a not blank column

edited 02/05/25 in Formulas and Functions

Hi! In a multi-select column, I'm trying to count the number of specific criteria and another column that is not blank. Both must be met and I'm unfortunately seeing an error message. Any suggestions? Thank you!

=COUNTIFS([Format Type]:[Format Type], HAS(@cell, "Live - Symposium"), [Format Type]:[Format Type], HAS(@cell, "Live - Congress"), [Approved 2024 $$]:[Approved 2024 $$], NOT(ISBLANK(@cell)))

Best Answer

  • Community Champion
    Answer ✓

    Did you want to check for either Live - Symposium or Live - Congress then you would need:

    =COUNTIFS([Format Type]:[Format Type], OR(HAS(@cell, "Live - Symposium"), HAS(@cell, "Live - Congress")), [Approved 2024 $$]:[Approved 2024 $$], NOT(ISBLANK(@cell)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions