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

COUNTIFS with OR
Hi everyone. I have a formula for which i have multiple criterion. The issue I am having is for one of the columns, I want it to be counted if it contains "x" or "y" or "z". I cant figure out how to phrase it appropriately and make it work. Here is my stab at it (but it doesn't work). =COUNTIFS({New Disposition Tracker(All…
AVG COLLECT GREATER THAN VALUE
I have a formula to calculate the average amount within a sheet. I want to change the formula to only collect and average any amounts that are >£10,000. =AVG(COLLECT({Archive Sales Amount}, {Archive Sales Stage}, "4 - Closed Won", {Archive Sales Level 1}, "1")) Thinking I may need IF and @cell but it keeps giving me…
Counting Days with plus or minus options
I know, I know… use =Networkdays([start date]1, [end date]1) HOWever, I am trying to track the performance of when a job is completed according to its due date. I found adding a -1 to to stop the inclusiveness of the calculation, whereas I can get a job completed on 10/5 that was due 10/6 to show 1 day using…