Why does Countifs doesn't work in some scenarios in some smartsheet.

I used this formula in one of the rows and it gave me the correct answere after I matched the range by using IFERROR in the columns of count. But the same in not working in another row.

Can someone help

=IFERROR(IF(COUNTIFS([Rack Suffix]:[Rack Suffix], [Rack Suffix]@row, [Rack Readiness]:[Rack Readiness], "=In Progress") > 0, "In Progress", "Ready to Move"), "")

Find more posts tagged with

Accepted answers

All comments

MedaUser

Hi @Namathew,

Your formula looks to be written correctly. What is the error your receiving?

Without seeing your sheet, it is difficult to determine what the issue is. In my experience with formulas, I like to work backwards to find the source of the issue with my formula, so in your case, I would start with determining what the output is if I simplified the formula to the countif function; i.e. =COUNTIFS([Rack Suffix]:[Rack Suffix], [Rack Suffix]@row, [Rack Readiness]:[Rack Readiness], "=In Progress"). If this output correctly, then I'd move on to adding in the If function and so on.

Namathew

Hi,

Thanks for your response.

I tried =COUNTIFS([Rack Suffix]:[Rack Suffix], [Rack Suffix]@row, [Rack Readiness]:[Rack Readiness], "=In Progress") and now it counts only the blanks in Rack Suffix, which is correct. The count for all Rack Readiness is 0, which is correct. Would you be able to help?

Victoria_Indimar

Hello @Namathew ! If the formula is copied exactly how you have it in your sheet, then I think the issue is you have quotations around "=In Progress". It should only include the words and exclude the equals: ="In Progress"

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.