Best Of

So many holes in the SS Functionality... The answer is "No" it cannot. SS Should be able to reference any form, sheet or sheet summary directly but for some reason it doesn't. I have a link I want to include in the workflow messages. To do that I have to set a column to a value to lookup those values form another sheet where all my links are located. I trick the column starting an INDEX function so I can use that to create a named reference to another sheet then remove the INDEX leaving the column function as just "{Othersheet:Myfiled}" and convert that to a column function.

With pointers, and addresses, it shouldn't matter and we should be able to reference other sheets without duplicating columns!

Hi @Kimbh

I use the Sheet Summary fields to count columns and rows and then multiply them to get total cell count.

TtlColumns: =COUNT([ColA]1:[ColZ]1) + COUNTIF([ColA]1:[ColZ]1, "") + 1

TtlRows: =COUNT([ColA]:[ColA]) + COUNTIF([ColA]:[ColA], "")

TotalCells: =TtlColumns# * TtlRows#

(Replace ColA and ColZ with your first and last column names)

In a new, blank first row, use an existing column to reference the TotalCells# field from the Summary pane AND have specific text (TOTAL CELL COUNT) in another column to use as a condition for automation. (I color this row orange.)

Automation notifies me when that number is greater than 350,000 and the other column contains the specific text.

When I reach the limit I delete rows. If we need to retain the info, I'll create a new sheet from the existing and then delete the data on the existing sheet. My example is an archive sheet that has rows automatically moved to it.

Hope this helps!

Thank you very much for your response, Louise! Definitely would be a good enhancement for future Smartsheet updates. I made a workaround by adding a new Automation Sent Checkbox column and changing the automation to:

Trigger: When rows are changed AND when 'Send Automation' changes to 'Checked'
Action: Request an approval.

Apparently, making an approval action sends the attachment(s) no matter when they were attached. Now the client just has to open the request to download the report(s). It seems to be working so far!