Copy Sheet Summary Fields to Different Sheet

ker9

Is it possible to copy sheet summary fields to a different sheet using automation?

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment so you'll have to copy them manually, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment so you'll have to copy them manually, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

ker9

Thanks for the quick response. I will do an enhancement request.

I guess I will try using a formula to insert the pertinent summary fields to hidden columns and then copy the row on a trigger.

Andrée Starå

Happy to help!

To make sure! Do you know that you can copy the structure of the Sheet Summary up to 20 other sheets?

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

ker9

My scenario is more about sending some of that sheet summary info to another sheet, whose owner has need to use it for a completely different task/purpose (a little bit of divide and conquer). My original sheet will be deleted when complete.

ker9

You can use templates with sheet summary - that seems to work and would not be limited to 20 sheets

Andrée Starå

Yes, that works as well!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!