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

edited 12/09/19 in Archived 2017 Posts


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



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



    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.



  • 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.



  • Bruno

    Thank you,

    problem solved :-)


This discussion has been closed.