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 Cell on a sheet that auto-adds form entries to the top row
I have end users submitting forms and the entries are automatically added to the top row.
I don't want managers to have to do any sort of parent/child indentation work after forms are submitted, so I've added a column where I have calculated the max value of a very important column and just copied that value all the way down the column...I selected the top cell in this column and then linked it to a cell on a different sheet for reporting purposes.
It occurred to me that since I can only link a single cell to the other sheet, the more rows I add, the more the row with the linked cell is going to move further and further down the page.
Questions:
-Is this going to break at some point, due to my setup?
-Is there a better way to accomplish linking the max value of a column on a sheet to a cell on another sheet while still being able to add rows to the top of the originating sheet?
Comments
-
Tamara,
There are two other option one is to have the new entries come in at the bottom rather than the Top.
The other is to have your row with the formula as the Last row i.e invert the process.
-
Thanks James. So I understand your response to mean that it's totally ok if the formula/linked row just keeps moving further and further down the page as new items get added. Thanks for the response!
-
Tamara,
Yes thats correct.
