-
Add a formula column to multiple sheets efficiently
Hi, I have a workspace with approx 1000 sheets in it - they are all based on the same template. Sometimes a user wants a new data/formula column adding to the template. I would like to know how i could then add this new column (and its formula if applicable) to all 1000 sheets in the workspace (without manually doing it…
-
Possible to create (or copy) a new column with same dropdown options from an existing?
Hi, This may be a very simple question and I'm just missing the answer somewhere, but is it possible copy a column with all the same attributes and drop-down choices, then I can just change the header label? I have a sheet that has numerous date columns, but the drop-down options are the same for each one. Right now the…
-
Multiple columns
Hi How do i add multiple columns at one time, as an example how do I add 50 columns at a time.
-
Browse Workspaces in the Sheet Picker for Copy/Move Row Automations
The new "search based" functionality for picking the destination for copy and move row automations has proven to be more painful than helpful. I wish I had screenshots of the old one, but it was much more user friendly. I'm putting this out there to hopefully get the new UI reverted back to the previous UI. 🤞
-
Formatting of Automated email text
I use a lot of automations that send customised email to contacts. These often contain instructions and multiple paragraphs of text. I find the 5 line box very restricting and hard to navigate and view my text to make sure it is accurate. I would also love to be able to have some formatting, such as bullet points, bold,…
-
Dropdowns Formatted as something other than Text/Number
With dropdowns only being able to be formatted as text/number this often necessitates the creation of extra formulas, automations or data shuttles, just to get the data back into the original format. It would be incredible to be able to use a dynamic dropdown of contacts or dates directly. With the future introduction of…
-
Access & Work Off-line within Smartsheet (Sheet level)
Enhancement Request: Access Smartsheet off-line and allow work to be saved for upload at a later time or once online access is available. The most common use case is travel (i.e. airplane, passenger in automobile). However, there are scenarios where internet service is compromised (i.e. warehouse buildout, remote areas…
-
Nested if functions
i have 2 columns set up one is titled INS it has four dropdowns. the other is titled AMT, the amount in the amt column is dependent on the dropdown column selection which is text.
-
Workflows, Can I "Hardcode" a person into the workflow that uses ROLES from another sheet?
Is there a way to "hardcode" an email address into a workflow? I have a specific user that I want to get this one workflow. But everything is set up based on "roles" that are feed in by a different sheet via a formula. My user would get ONLY this one, rather than everything this user gets. Will I have to extend my sheet to…
-
Allowing views to pick columns to show
I'm sure this is already requested but I may have overlooked it. We have many columns that are used by automations and the team using the sheet don't need to see. It would be nice to create views where you could select the columns in a sheet to allow for better column spacing and less data to scroll through.