COUNTIF Formula for Checkbox Column on Another Sheet

regina.quality

regina.quality ✭✭✭

08/01/24 in Formulas and Functions

Any Formula to count how many rows are checked off in a checkbox column on another sheet?

0 ·

Answers

Matt Lynn ACT Community Champion

08/01/24

@regina.quality =sumif(<Insert ref for cross sheet ref>, 1)
The checkbox has a numeric value of 1 if it's checked and a 0 if it's not.

Matt Lynn
How can I help? Schedule some time on my calendar: CLICK HERE
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

IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…
Who can help identify my issue with cross sheet index matching formula?
Hello, Wondering if anyone can help me with finding the error in my formula: =INDEX({Destination Care Fund Statement of Need Range 1}, MATCH({Destination Care Fund Statement of Need Range 2}, [MRN], 0)) Range 1 and range 2 information populated when I clicked the column in the selected sheet from reference another sheet I…
How to return the last recorded date in a column?
I have a % Complete column and a deadline column. I'm trying to write a formula for when [% Complete]16 equals 100% it returns the last recorded deadline. I'll use this to record the end date of a project. [% Complete]16 is the bolded cell which is averaging the children. The deadline that should return from the formula is…