Incorrect counting of blank rows

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNT([Completed Tasks]:[Completed Tasks], IF([Task Name]:[Task Name], ""))

I have a checkbox column that will read in the summary bar (row 1) when working "Completed 6 of 33" However, it is counting blank rows and should read "Completed 6 of 25"

The formula is in the checkbox column, and I attempted to have it reference the Task Name column, if blank then don't count. but i can't get it working. Please help!

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

My apologies. Try this...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

All comments

Paul Newcome

Give this a go...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1))

Angela Ryer

It still counts empty rows.

This should be more like 2 of 25 but is counting the entire column even if the row is blank. (Which is why i tried to use [Task Name] to only count if not blank. But i'm happy to do it any avenue that gets it working.

Any other suggestions?

Paul Newcome

My apologies. Try this...

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

Angela Ryer

awww, yes! thank you!!

="Completed " + COUNTIF([Completed Tasks]:[Completed Tasks], 1) + " of " + COUNTIFS([Completed Tasks]:[Completed Tasks], OR(@cell = 1, @cell <> 1), [Task Name]:[Task Name], @cell <> "")

Paul Newcome

Happy to help! 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.