Collect Counts From Multiple Sheets

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.


Best Answer

  • CodyRussell
    CodyRussell ✭✭✭✭
    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")

Answers

  • CodyRussell
    CodyRussell ✭✭✭✭
    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")

  • RJT
    RJT ✭✭✭✭

    Cody,

    That worked perfectly. Thank you so much.

  • CodyRussell
    CodyRussell ✭✭✭✭

    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). :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!