Sheet summary query

vipa2000

I have created a number of sheet summary fields i.e. =COUNTIFS(CC:CC, "120802", [Principal Action]:[Principal Action], "Full Topo including underground services") that pertain to one plant; in this case 120802. I now want to copy this and rename to another plant. I cannot seem to find a quick way to simply copy and rename? I have around 10 that I need to copy x6 (number of plants) so help greatly appreciated. Regards Paul

Andrée Starå

@vipa2000

Happy to help!

Unfortunately, it will overwrite/replace it completely.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @vipa2000

I hope you're well and safe!

Here's where you can select the Copy to other sheets option.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

vipa2000

Hi, tried that prior to posting. You can only copy to another sheet? Regards Paul

Andrée Starå

@vipa2000

Not sure I follow.

What would you like to do?

vipa2000

Hi Andree, I need to duplicate the summary field in the same sheet and change the 120802 to another number. I have about 60 I need to do in total to then feed a dashboard. Regards Paul

Andrée Starå

@vipa2000

Unfortunately, it's not possible at the moment to copy Sheet Summary Fields to the same sheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

vipa2000

Thanks Andree. I tried something yesterday and then stopped, perhaps you may be able to confirm. I thought what if I create a dummy sheet and send the summary fields (copy) to another sheet and then send back with new names. When I got to the final stage it said something about summary fields already existing, ok to overwrite? Does this mean all exiting summary fields would be overwritten? If I get chance later I will try with all new dummy data.

Andrée Starå

@vipa2000

Happy to help!

Unfortunately, it will overwrite/replace it completely.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!