Summary Sheet Formulas

tblocker

tblocker ✭✭

07/25/24 in Formulas and Functions

I have a column named complete, and I want to track how many items are checked Yes.

I'm currently trying to use

=COUNTIF(

But I cannot figure out the range/criterion values I need to use.

0 ·

Answers

heyjay ✭✭✭✭✭

07/25/24

=COUNTIF(complete:complete, 1)

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

Form field controls so data entry is required to sum 100 percent?
We're sending out a survey to understand how much time employees are spending working for each of two departments. We want employees enter time spent as a percentage to add up to 100%. For example an employee might enter 40% for dept "a" and therefore they have to enter 60% for dept "b". Or better yet, whatever they enter…
COUNTIFS formula not working for larger data set
I have a COUNTIFS formula that works when looking at a single column, however when I expand the formula to include a full range of columns (37), I receive an Incorrect Argument Set error. The formula below looks at a column and essentially counts all values as long as it is not blank. It also compares it to a date column…
COUNTIFS Struggle – Need a Hand!
Hi everyone! I'm looking for some help with a COUNTIFS formula. I'm trying to count how many contractors vs. employees we have on a sheet. Counting employees was straightforward since there's only one type. However, there are multiple types of contractors, and I'm not sure how to count all of them together. I've attached…