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

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would use something along the lines of...

=COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, Completed:Completed, @cell = 1) + "/" + COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, Completed:Completed, OR(@cell = 1, @cell <> 1))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.