COUNTIF and Multi-Select

Kara Lumley

Kara Lumley Employee

10/07/19 edited 12/09/19 in Formulas and Functions

Hello all,

Here is a sheet with examples of how to use a COUNTIF formula the release of Multi Select.

Hope it helps!

Best,

Kara

Tags:

Formulas

0 ·

Comments

Andrée Starå Community Champion

10/07/19

Hi Kara,

Excellent!

Thanks for sharing!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share 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!

Trending in Formulas and Functions

Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
My formulas on my Metric sheet are calculating 0 and I'm not sure why
Hello, I am trying to create a dashboard with widgets to display our overall progression on multiple projects. I was told a Metric sheet would be best to do this. I am creating my first metric sheet but the formulas are calculating 0 and I'm not sure why. In the first section below I am wanting to add up how many projects…
How do I use Cell reference in a formula when using Index?
I have a simple table that has the following columns (along with other columns), ZZZ YYY 10 15 and I would like to replace the ZZZ and YYY in the following formula =INDEX([Thing1]ZZZ:[Thing2]YYY, 1, 1) With the data from the columns above so that the resulting formula would be: =INDEX([Thing1]10:[Thing2]15, 1, 1)