Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Calculation Formula Help

    ✭✭✭✭✭
    in Formulas and Functions

    Hi all! Here is a snip of the columns on a separate sheet that I am referencing in my formula:

    image.png

    I need to count how many times a survey is completed each month in each area. I have a total submissions section where the total number of submissions is a rolling count, but I need to drill that down to show, for instance, how many times A2 completed a survey in January 2023. I thought I could use a sum or count formula, but I can't make it work in my head.

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭✭✭
      Answer ✓

      Hey @tmichelle068

      You'll want to use a COUNTIFS formula for this, listing multiple conditions.

      To use your example, you could have something like:

      = COUNTIFS({Area Surveyed:}, = "A2", {Month Completed}, = "January")

      This is just a sample of the form it would take; the ranges will refer to the columns in your reference sheet, & the criterion will be next to their respective column references. With COUNTIFS you can list as many ranges/criterion as you need.

      Let me know if you need more help! I hope this was useful 😊

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭✭
      Answer ✓

      Hey @tmichelle068

      You'll want to use a COUNTIFS formula for this, listing multiple conditions.

      To use your example, you could have something like:

      = COUNTIFS({Area Surveyed:}, = "A2", {Month Completed}, = "January")

      This is just a sample of the form it would take; the ranges will refer to the columns in your reference sheet, & the criterion will be next to their respective column references. With COUNTIFS you can list as many ranges/criterion as you need.

      Let me know if you need more help! I hope this was useful 😊

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭

      Wow I was making that WAY harder than it needed to be in my head HAHA! Thank you so much!

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭

      @tmichelle068 Happy to help! Feel free to mention me if you need more help in the future, I do this kind of thing all the time 😊

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions