How to add a percentage/fraction progress counter for checkboxes

Hi,

I have a sheet with multiple tasks on indents assigned to people (names on outdents), each task has a checkbox for when it's completed. Is there a way to make a counter for each person for how many tasks they have that shows how many are ticked?

e.g. 20/100


I've figured out the countif to count how many are ticked on a specific range in the checkbox collumn but would like a fraction of completed tasks.


So in the 'No. of completed SKUs' collumn I'd like it to be 20/100 for example.


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!