-
'Helper' Column Management via New Column Type (or Side Panel?)
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…
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Dropdown List, "Allow Multiple values per cell", provide an option to "Limit number of selections""
When working with a Dropdown List, it would be nice to be able to limit users to selecting X number if we have the "Allow multiple values per cell" option selected. Here is a concept art of what I'm imagining: Of course you could leave the value blank or have 0 be "unlimited". This could then transpose over to Smartsheet…
-
How to link a column to a different sheet that auto populates when new rows are added?
I'm trying to do a workaround to adding multiple rows from the same form. I created a new sheet that has columns for requests 1-10. I want to pull certain columns from that sheet to move to a new sheet and then I can use a workflow to transfer that to my main sheet. I've created an ID column that autogenerates a number as…
-
How to give access to specific people ONLY to specific columns of a master sheet?
Dear Smartsheet team, I would like your input on the following topic: We have created a Workspace for one of our customers, that contains a master sheet that stores Tactics, with various different columns. We have a request from our customer, to add 4 more columns to this master sheet, related to the Tactics, and give…
-
Merged: Column Header Color Fill
This discussion has been merged.
-
Merged: Customizing Column Headers
This discussion has been merged.
-
Merged: Modify formatting in column headers
This discussion has been merged.
-
Importing Emails of Users, Smartsheet Not Converting to Contact First and Last Name
Hello! Has anyone figured out a way to load a column of emails or names, any combination really, into a contact column on a sheet where the user's first and last name appears rather than just the user's email? We're working on a large list that will be a source table for numerous systems and I want to user's contact to…
-
Order of the columns in a sheet
Being able to select or modify the order of columns in a sheet in bulk, for example: Creation date Column Type Alphabetical Order A-Z / Z-A