Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Summary table - parsing a table of variable qty of records

Options
Bruno
Bruno
edited 12/09/19 in Archived 2017 Posts

Hi,

I have a sheet which is an action tracker

Actions are adding to the sheet as added rows.

 

I am willing to make some stats andI have to parse the full sheet from top to bottom using countifs functions and alike.

 

PB: my sheet is constantly increasing in length, hence my countifs formula does not parse the full sheet unless I manually update it.

 

Is there a way to have that done automatically?

 

Thanks and warm regards

Bruno

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Bruno,

     

    If your formula is not in the same row as the criteria or count, you can reference the entire column

     

    =COUNTIF([My Column]:[My Column],"Red")

     

    will check the whole column, including added rows, for the text or symbol "Red"

     

    Hope that helps.

     

    Craig

  • thadr
    thadr
    edited 03/23/17
    Options

    Hi Bruno,

     

    New to the community but not new to smartsheet or spreadsheet functions. I haven't had to gather stats like your scenario below but I have done something similar in my past life with spreadsheets.

     

    Have you tried calculating your stats at the top of the sheet and take into column into consideration for your formulas rather than just your rows? If you do a countif for your column, it will always come back with the correct number even when additional rows are being added.

     

    I hope this helps.

     

    Best

  • Bruno
    Options

    Thank you,

    problem solved :-)

    Happy

This discussion has been closed.