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

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

· Share on FacebookShare on Twitter

Comments

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

    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

    · Share on FacebookShare on Twitter
  • thadr
    thadr ✭
    edited 03/23/17

    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

    · Share on FacebookShare on Twitter
  • Bruno
    Bruno ✭

    Thank you,

    problem solved :-)

    Happy

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories