Automate Row reference in Sheet Summary Field

Options

Hello,

I have a sheet that regularly updates with new rows. I use the "Sheet Summary" tool to summarize columns of data that are then shown in reports. Whenever a new row is created in this sheet (by a form), the sheet summary field does not update to include that row in the summary.

Is it possible to have the sheet summary formula include ALL rows, or update the row reference as new rows are created?

Best Answer

  • SJ Sellers
    SJ Sellers ✭✭✭✭
    Answer ✓
    Options

    Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

    My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

Answers

  • SJ Sellers
    SJ Sellers ✭✭✭✭
    Answer ✓
    Options

    Can you share the formula you are using in your Sheet Summary? That will help troubleshoot your issue.

    My guess is that you are using a range (Amount1:Amount14) rather than a column (Amount:Amount) reference, but that's just a guess without other information.

  • Bennett R.
    Options

    Hi SJ,

    I am using quite a few, but here is a countifs formula that should show what what i'm doing for most.

    I use similar formulae for sumifs for the same data sets.

    =COUNTIFS([Sub-SBU]1:[Sub-SBU]36, "Hardlines", [Project Type]1:[Project Type]36, "Productivity")

    I'll try =COUNTIFS([Sub-SBU]:[Sub-SBU], "Hardlines", [Project Type]:[Project Type], "Productivity")

    and see how the goes.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!