Help with COUNTIFS Formula

Options
Peppey
Peppey ✭✭
edited 08/15/22 in Formulas and Functions

Hi everyone!

I am hoping someone could please help me. I need a formula that will count the number of times an action is complete (shown in the formula as CY22 Post Selection Support Inventory Range 9), and by a specific person who completed the action (shown in the formula as CY22 Post Selection Support Inventory Range 6}, CONTAINS("John Doe", @cell)).

The CY22 Post Selection Support Inventory Range 9 is a date column and the CY22 Post Selection Support Inventory Range 6 is a drop down column as text.

The complete formula I have written is below

=COUNTIFS({CY22 Post Selection Support Inventory Range 9}, <>"", {CY22 Post Selection Support Inventory Range 6}, CONTAINS("John Doe", @cell))

Any help would be greatly appreciated.

Brian

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!