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)")

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!