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.
Calculate with row numbers / Formulas not copied after adding new rows
Every now and then I notice that formulas are not copied when a new row is added to a sheet. Very often these formulas are placed in hidden columns and so it's not immediately obvious.
So, I'm looking for a way to get an "alert" in a cell within Smartsheet whenever a cell in a specific range is empty, showing the amount of blank cells. I know the first and the last row of the range, but the count of rows in between can vary...
I could manage to get the count of cells with a specific content within a given range, but if I want to be alerted, I need a value to compare the result with...
Total amount of rows=5
Total amount of non blank cells=4
In Excel one can calculate with a row number with the following function:
This formula returns the number of the row. One can use it to count the number of rows between a specific range. But it seems that Smartsheet does not support this function.
I could not manage to use "count(children())" because children may again have children and with this formula you do not get the grand total of children and grandchildren.
At the moment I'm lost ;-)
Does anyone have a solution or hint how to get this working?