Help on Countifs Formula

Josh B

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.

JB

Paul Newcome

Try using a CONTAINS function like so...

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

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! 👍️