Report Counting and Summing Incorrectly

Options

I am making a report where I want to pull budgets from multiple sheets and see the total spend by channel, but the report is not pulling in all the rows. I'm not sure what is wrong to prevent some of the rows to not being pulled in. What can I do to get all rows to be pulled into the summation?

Below is a screenshot using Count to show that only 20 of the 26 rows are pulling into the summary section, and the next screenshot shows my actual goal of summing all the budgets:


Answers

  • AravindGP
    AravindGP ✭✭✭✭✭
    Options

    Hi @aplunkett02


    I tried simulating the values and got the count to be 26 and the total to be $2,513,051. There might be a formatting error in six of these sheets, which is causing the total to be lesser than it actually is and hence the count is also not matching. Try doing a count against the Sheet name and you should get 26.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • aplunkett02
    Options

    Hi @AravindGP

    It won't let me count the sheet name, possibly because it is a primary row, but also when adding an additional non-currency row, it still only counts to 20.

  • AravindGP
    AravindGP ✭✭✭✭✭
    Options

    Thanks for the response @aplunkett02


    If you're comfortable to do a screenshare call, I can try to help (you can ping me at aravind.gp@atturra.com). If not, you can possibly raise a support ticket with Smartsheet.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!