Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
Comments
-
Hi! It's possible that this is a bit lazy of me, but I would love to add an option to duplicate sheet summary fields!
I often use them to count totals or calculate metrics in my sheets and when I have a lot of criteria to measure, that means a lot of clicking back and forth to make a new field, write in a new name, copy/paste or retype (often complex) formulas and (if I copy/pasted) edit the formula to change the criteria. It would be so much faster if I could duplicate the same field over and over and just change the name and the necessary criteria in my formula rather than having to make them from scratch all the time!
-
you can copy an entire sheet summary to another sheet.. know it's not exactly what you're after here, but that does provide the same affect (you'd just have to delete the additional summaries you don't need).
