- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Are there ways to have different, overlapping groups of columns?
Hello - Are there ways to have multiple overlapping groups of columns? Right now, the best I can come up with is a script at the top right to select predefined columns, which is servicable until you have a bunch of scripts in addition to your grouping scripts, so if there's another way to do this, it would be nice.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Are there ways to have different, overlapping groups of columns?
If you want to have single column in multiple groups (or rather change the groupings) you would have to do it by scripting. I would most likely create some sort of an add-in which would let be define the groups, change the groups, possibly save them to a file for easy loading/table variable and add those group "swaps" to table scripts for easy usage.
This might give some ideas Save Current Column Order and Grouping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Are there ways to have different, overlapping groups of columns?
One way to handle this is by creating new formula columns who's formula simply points to the original column. The new formula column can then be put into a new group.