-
"Import" > "Update Rows"
I want to import data to an existing data sheet whereby it will upload the data from my source sheet excel to my existing data set and match by the unique identifier I found the below instructions but the "Import" > "Update Rows" option is not available, can someone guide me on how to access this option? Yes, in…
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…
-
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
Need help calculating hours allocated per week for team members
I need help creating a formula to calculate how many hours my team is allocated for per week. I have three columns in my sheet that we use for task management. Hrs per week - is a number on the hours it takes Assigned to - is a manual text field of the team member who is doing the task Due Date - when it is due (typically…
-
Filtering based on Multi Select Dropdowns
In the calendar app, you are unable to filter using a multi-select dropdown column which makes it very challenging to view specific pieces of information. It would be so helpful to have this!
-
Automated copy row to a new grid
When the automation copy row to new grid when the criteria is triggered; can we make a selection for only x amount of column to be copied and not all columns from the original gird?
-
Seeking ideas and best practices for centralized intake form
The communications and marketing functions at our company recently all merged into one large team. We're now working on creating a new, centralized intake form to capture all incoming requests. However, several functions (e.g., employee comms, graphics, events) have existing Smartsheet forms that they've been using for…
-
Help on using Lean Six Sigma Project Template Set
Hi everyone, I am thinking of using the Lean Six Sigma Project Template Set. I am a Master Black Belt but have not been fully utilizing the DMAIC project management, This is a great template set, but I have some questions. Is there a training somewhere that is specific to this template set? Thanks for your help. Freda
-
Increase the limit within Contact List column
Currently there is a limit of 20 contacts within the Contact List column, which is not sufficient for our needs. It would be great to either increase the maximum to a significantly higher number, or removing the limit whatsoever.