Sign in to submit new ideas and vote
Get Started

'Helper' Column Management via New Column Type (or Side Panel?)

Kevin M.
Kevin M. ✭✭✭✭

Many of us, if not most, use one or more helper columns to achieve the Sheet functions that we need. Good practice is to hide the helper columns (when possible) so that the sheet user isn't bombarded with noise.

Unfortunately, hidden columns still appear while in Card View. My solution for this is to move all of the helper columns to the end of the sheet, add a new column to the right of the last column of relevance to the sheet user and populate it with "🛑 End of Card 🛑" or something similar. When scrolling down the card, the red stop sign emojis stand out and the user knows they don't need to scroll through the remaining n fields.

A new Column Type named "Helper" could solve this. It would be even better to build this in conjunction with a menu option to specifically Hide/Unhide Helper Columns.

Hidden columns of the Helper type would:

  • not appear in Card View
  • not appear in published versions of the sheet
  • not appear in the column selection dropdowns for report and sheet filters OR,
  • ...simply shove them to the bottom of these lists and denote their helper status somehow (Italics, perhaps?)

Hopefully, the community can help me fine-tune this feature request.


P.S. I thought of the "column type" solution while typing up another solution idea for this problem. If the above doesn't gain any traction, maybe this will:

. . . [H]ow about adding a new panel to the right-side toolbar -- similar in function to the Sheet Summary panel -- to contain the helper formulas. Each row could look at the specific value for the helper formulas for that row.

Helper columns could be "moved" to this panel via a toggle in the context menu when right-clicking on the column header, similar to the Lock/Unlock Column toggle. Perhaps this option only appears if the column has a column formula.

11 votes

Idea Submitted · Last Updated