-
Conditional formatting OR option
Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating!
-
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...
-
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.
-
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…
-
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.
-
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…
-
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…
-
Data Shuttle - add in rows with out Unique Identifiers
The concept of this idea for the "Data Shuttle" aims to overcome the current limitations in data integration, specifically focusing on accommodating users who wish to incorporate rows without the requirement of unique identifiers. The Challenge with Unique Identifiers: At present, Smartsheet mandates the presence of unique…
-
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…
-
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…