Counting 2 items

Options

Amanda Schiavetti

Amanda Schiavetti ✭

06/20/25 in Formulas and Functions

Hello can someone help me with counting if the location is MTC and Procedure is 94060- Spiromtry?

0 ·

Best Answers

Darren Mullen Community Champion

06/20/25 Answer ✓

@Amanda Schiavetti
Yes, using Countifs() and has()
=countifs(Location:Location, "MTC", Procedure:Procedure, has(@cell, "94060- Spiromtry"))

Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
0 · Share on Facebook Share on Twitter
Amanda Schiavetti ✭

06/24/25 Answer ✓

Thank you @Darren Mullen

0 · Share on Facebook Share on Twitter

Answers

Darren Mullen Community Champion

06/20/25 Answer ✓

@Amanda Schiavetti
Yes, using Countifs() and has()
=countifs(Location:Location, "MTC", Procedure:Procedure, has(@cell, "94060- Spiromtry"))

Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
0 · Share on Facebook Share on Twitter
Amanda Schiavetti ✭

06/24/25 Answer ✓

Thank you @Darren Mullen

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

Net Days showing 36500 no matter the actual dates provided.
I am trying to use the NETDAYS function, but it will only respond with 36500. The result should be like 60. The dates I am trying to count are part of some simple (COLUMN + COLUMN) formula.
Trying to return 3 months prior to Date Column
Hello, I am trying to make a column to return dates 3 month before the date in another column. Essentially going to be notifying teams 3 months before something expires. I have a column for the dates. It is set to "date" and i'm using this formula in a helper column =DATE(YEAR(DATE@row ), MONTH(DATE@row ) - 3, DAY(DATE@row…
Move data from a column into a cell
I would like to pull the name that is listed in the Name column into the Primary Column. Note that the name could be listed multiple times in the Name Column.