Help on Countifs Formula

Hello Smartsheet Community,

I'm looking for some guidance on a countif formula. Specifically, i'm trying to count a specific request type where multiple types of requests can be submitted with a single request. My current formula is counting my criteria, however if another type of request is selected i.e. 2 or more, it doesn't count in my totals.

Formula: =COUNTIFS([Type of Request]:[Type of Request], "Remove Form(s)")

Screen Shot 2020-05-12 at 10.42.02 PM.png

So in the image i'd like to count both requests individually toward a grand total one for "Remove Form(s)" and one for "Update/Replace Form(s)".

Any help or pointers are appreciated.

Thank you in advance.

Find more posts tagged with

Accepted answers

Paul Newcome

Try using a CONTAINS function like so...

=COUNTIFS([Type of Request]:[Type of Request], CONTAINS("Remove Form(s)", @cell))

All comments

Paul Newcome

Try using a CONTAINS function like so...

=COUNTIFS([Type of Request]:[Type of Request], CONTAINS("Remove Form(s)", @cell))

Josh B

Thank you very much, @Paul Newcome . That did it! Have a nice rest of your week.

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.