-
Exclude blank fields from automation
Hello I set up an order form that contains all the items available to have their own column and as mandatory fields the user enters their name, email, managers name & email. This allows the user to complete 1 form only. They can order 1 item per category. Generally out of 10 products, staff only need 2 which means i have…
-
'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…
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
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…
-
Dropdown List option to hide 'Select All'
If a dropdown list can have multiple values in a cell it adds an option to 'Select All'. There should be an option the in properties to hide this where selecting all values makes no sense.
-
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.
