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.

    Collect Counts From Multiple Sheets

    ✭✭✭✭
    in Formulas and Functions

    Happy Wednesday Smartsheet Community. I have another issue where I am attempting to collect system type counts from three multiple sheets. Unfortunately I have not been able to get the formula to accomplish this. Below is formula using to attempt the compilation

    In the formula I am asking to pull from the P931 Admin Sheet, P931 F&B Sheet and the P931 Tech Warehouse Sheet where I select the System Type column to pull counts on all "Food Point of sale Indoor" system.

    =COUNTIF({P931 - Admin Bldg - Deployment Device Count}, "Food Point of Sale Indoor"), ({P931 - F&B Warehouse - Deployment Device Count}, "Food Point of Sale Indoor"), ({P931 - Tech Warehouse - Deployment Device Count}, "Food Point of Sale Indoor"))

    Below is example of sheet where I am attempting to pull the system type from. Each of the three sheets have this column. Just trying to build a formula that will reference all three sheets from this column and return the total collective count. I appreciate any and all help. Thank you.

    image.png


    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭
      edited 03/13/24 Answer ✓

      Try this:

      =COUNTIF({P931 - Admin Bldg - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - F&B Warehouse - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - Tech Warehouse - Deployment Device Count}, "Food Point of Sale Indoor")

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭
      edited 03/13/24 Answer ✓

      Try this:

      =COUNTIF({P931 - Admin Bldg - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - F&B Warehouse - Deployment Device Count}, "Food Point of Sale Indoor") + countif({P931 - Tech Warehouse - Deployment Device Count}, "Food Point of Sale Indoor")

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Cody,

      That worked perfectly. Thank you so much.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Awesome, I'm glad that worked for you!

      The issue was that your initial formula was a single countif, which you wanted to count and then sum three unique values.

      Two ways to do this in the future would be a countifs formula, or by adding the values of individual count if statements like I did above(countif+countif+countif). :)

      · 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

    • Formula Help

      I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
      User: "Allan Z"
      Answered ✓
      Formulas and Functions
      9
      2

    • Unparseable Error

      Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
      User: "stratman"
      Answered ✓
      Formulas and Functions
      15
      2

    • Formula to return the non-blank cell

      I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …
      User: "m_anderson"
      Answered ✓
      Formulas and Functions
      13
      2