How do I do this formula?

Please help!!

Hi there! Im new to Smartsheet and helping my team get on track with using it.

I am having difficulty doing a specific formula if possible -

I need the total amount of rows that meet a certain criteria…like columns that have triggered GROUP A and also IP , total amount of rows that are GROUP B and IP, etc. These are drop down select columns.

GROUP has GROUP A, GROUP B

FACILITY has IP, ER

Example.

Number of people in Group A and in Facility IP = 2

Number of people in Group B and in facility IP = 0

Find more posts tagged with

Accepted answers

Mark Rojas

@walcala this is how I have it set up

~MR

All comments

Mark Rojas

@walcala

Your general format will be like this: =COUNTIFS([Group:Group], @cell = "Group A", [Facility:Facility], @cell = "IP")

Then just substitute the "text" for your criteria. If its a cross sheet formula then the [Group:Group] will look like a {Cross Sheet Reference}

~MR

walcala

@Mark Rojas Thank you for replying so timely!

I tried it on my sample sheet and I got an unparseable error.

Mark Rojas

@walcala can you share a screen shot of the grid and the formula?

I tested this on a copy of your original post and it worked just fine.

~MR

Mark Rojas

@walcala this is how I have it set up

~MR

walcala

@Mark Rojas I tried it again after a shot of espresso and it did work… It was all human error on my part. THANK YOU SO MUCH FOR YOUR HELP!

Mark Rojas

@walcala Of course!

~MR

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.