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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!