-
COLLECTMOD() formula
=COLLECTMOD([Return Range],"Modify Return Range",[Range 1],"Modify Range 1", "Range 1 Criteria", ...) Leave blank if there is no modification to the range.
-
Cell linking and the addition of new rows in master
Please configure cell linking to reflect the addition of rows in the master to the linked sheet. We are constantly adding new rows of data to our sheets and would love if those were reflected in the subsequent sheets. Hard to believe this is not already implemented into your system...
-
Update Sheet Summary with Automations
It would be very convenient if we were able to do update requests and cell changes via automation for the sheet summary section. Right now it's out on it's own and forced everything to be done manually. Limits the effectiveness of the tool. For example, we keep "Status" in the sheet summary, and I want to be able to update…
-
JOINARRAY() function Idea
=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed. =JOINARRAY(", ", A:A, " ", B:B) results in: x 1, y 2, z 3 blank values are ignored, hence the over-ride for the end of the item delimiter
-
Drill down feature in Smartsheet Dashboard
It will be good to have a drill down on bar graph(individual bars/data)in Smartsheet Dashboard just like Power BI.
-
Resetting Auto-numbering for columns in templates and sheets
Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you…
-
Editable Date and Contact Fields in Outlook Add-In
Presently the Outlook add-in for Smartsheet does not allow you to edit date or contact fields. I feel like it would be beneficial for those that track tasks in Smartsheet (from email requests) to assign due dates and email addresses in contact fields. We currently use a department smartsheet and a contact column to tell…
-
Budget and prognosis synchronisation between Resource Management and SmartSheet
As it is now, only very few data fields can be synchronised between a project in Resource Management (RM) and SmartSheet (SS). There is currently no way to automatically synchronise any overall project information (budget, incurred, prognosis, total budget, expenses) from RM to SS. Our team uses RM for all our specific…
-
Rename Smartsheet Outlook add-in button
I would like to be able to rename the Smartsheet Outlook add-in button. At the moment the button name is huge and is taking up way to much space on my menu bar. The name is currently "The Smartsheet for Outlook Add-In". I want to change it to "Smartsheet". Or, if renaming on demand is not an option, can Smartsheet at least…
-
Open files in a new window
A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…
