Counting formula-checked check boxes in sheet summary column - returns Invalid Data type

Hello,

I am working on a project that is counting checked checkboxes that are checked via a column formula. I have tried changing to a COLLECT and a VALUE function but neither seem to work.

Summary Formula currently: =COUNTIF(VALUE([At Risk]:[At Risk]), =1) - Returns Invalid Data Type

Checkbox column formula: =IF(OR((AND([% Complete]@row <= 0.5, NETWORKDAYS(TODAY(), Finish@row) <= 10)), (AND([% Complete]@row <= 0.75, NETWORKDAYS(TODAY(), Finish@row) <= 5)), (AND(Status@row = "Not Started", NETWORKDAYS(TODAY(), Finish@row) <= 5)), AND([% Complete]@row < 1, Finish@row < TODAY())), 1)

Any help would be appreciated!

Find more posts tagged with

Accepted answers

bisaacs

Hey @Mross0878,

In your At Risk column, are there any cells that show "Invalid Data Type"? I just discovered that if a row in the At Risk column has "Invalid Data Type", that also gets sent to the Summary Field.

All comments

bisaacs

Hey @Mross0878,

I think you're receiving an error because you put the '=' in the criteria for something that's not a number. Checkbox columns just use the 1 and 0 as indicators, not as actual numbers. This should work:

=COUNTIF([At Risk]:[At Risk], 1)

Hope this helps!

Mross0878

https://community.smartsheet.com/discussion/comment/436296#Comment_436296

Sorry, it didn't fix the issue!

bisaacs

Hey @Mross0878,

Weird….And the summary field is a Text/Number field?

I just tried using the formula you provided and I'm getting an unparseable. Is that formula working for you?

Mross0878

https://community.smartsheet.com/discussion/comment/436303#Comment_436303

The Summary is a Text/Number and yes it looks to be working. I did not create the original column formula, I was pulled in after the fact, but it looks to be functioning.

bisaacs

Hey @Mross0878,

In your At Risk column, are there any cells that show "Invalid Data Type"? I just discovered that if a row in the At Risk column has "Invalid Data Type", that also gets sent to the Summary Field.

Mross0878

https://community.smartsheet.com/discussion/comment/436307#Comment_436307

Yes there are. Let me review what happened to those and get back to you! I'll respond again if that fixes it!

Mross0878

https://community.smartsheet.com/discussion/comment/436307#Comment_436307

That worked. I added an IFERROR to the column formula to set errors to unchecked. The errors were from dates that have not been entered yet. Thank you for all your 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.