Formula help: Counting user experience by date


Hi there,

I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N/A) for each month. For example count if a response is in September and it is positive.

I am referencing a different sheet and I have tried a few different formulas but I keep getting errors.

I am assuming I need to use =COUNTIFS - however, I cannot get the formula to work and I know it's a user error on my end.

Here is a bit of dummy data from my reference sheet

Any help would be greatly appreciated


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!