-
Adding Data Rows for Dashboard charts requires reformatting?
I created a sheet to put my data in and created a bunch of charts tied to it. For example, each row represents that week's data. BUT . . . as I add new rows of data for new weeks, I'm finding I have to re-establish the data field for the charts and when I do, I lose all of the formatting for the chart and have to reset all…
-
Enhancement Request: Allow Excel import without formatting
I would like to be able to import an Excel file without formatting. Use Case: I have a customer using an (older?) ERP. The ERP can export to Excel. After row 99 of data, the Excel file changes format. They probably thought that was a feature. I'd like to import the Excel file to Smartsheet without formatting to avoid extra…
-
2-Way Cell-Linking
I frequently link cells because it is very convenient. Could it be possible to enhance this, so that one doesn't have to use "Go To Sheet" in order to update the value? In other words, can we have 2-way linkage, so that if it's updated in either place, then the value has been updated? I constantly have to go to source…
-
One task split into multiple periods
Hi Smartsheet! I have used Smartsheet at my former job and have now recently switched job and am evaluating what PM tool to use within the new company. The overall experience from working with Smartsheet has been positive but the tool however has one very critical shortcoming as I see it (at least for how we wanted to use…
-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Document Preview Pane
It would be nice to view documents attached to a row in a preview pane while being able edits the row fields at the same time.
-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
Spreadsheet Filters vs Report Filters
I have a text column that has formulas and conditional formatting already added to it preventing me from changing the column type to a dropdown list. It is spread across several years of spreadsheets making a larger conversion to a list time consuming. I have a request for Report Filters to have the drop down list similar…
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
Common Picklist
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?