-
What is the best way to consolidate data from multiple sheets?
I have multiple projects running side by side and I need a method to view a high level overview of all my projects with real data and a Gantt chart. I know I can use reports but reports do not support Gantt charts or a calendar. Does anyone have a better solution for how to do this?
-
Enhancement Request: Sights Auto-Refresh
We have created a departmental dashboard and we're displaying it on a 40" LCD. It looks completely awesome and we are now the envy of all other departments... BUT, the screen doesn't automatically refresh. We created a script that automatically refreshes the screen every 5 minutes and that is working to update the data,…
-
Round the clock schedule
Hi, when planning / executing big IT application cutover or implementation, which sometimes can span for 1 week, the involved teams will work in shifts in a 24 7 schedule. To track all this work and its dependencies, a detailed schedule is created including start date, start time, finish date and finish time with time…
-
Add the ability to use array formulas?
I would like to be able to use an array formula like Excel has so I can recreate my fee estimate sheets in Smartsheet. It does not appear like Smartsheet can do this. Can you please add this capability to Smartsheet?
-
Automate Child Row Based on Parent Row
Hello SS community. I am curious to know if there is a way to update a child row based on a parent row. My real world scenario is as follows. I move children rows physically on the page into one of 6 sections contained by parent rows. When I move a row into the 'Completed' section, I would like the status column to change…
-
Messaging collaborators
With so many collaborators working at any given time on the same sheet (you can see when someone enters or leaves a sheet), has any thought been given - is it even possible - to having an IM-type feature whereby you could message others in the sheet at the same time? We already have IM software internally which we use…
-
Set a dropdown value for all selected cells
For nested items especially, it would be nice to select multiple rows' dropdown cells, right click, and set a dropdown value across all those that are selected. So, 5 nested rows whose parent's dropdown for "status" is set to "complete". I'd like to be able to select cells from that same column for the nested rows and…
-
Add Trend Lines/Line Graphs to SIGHTS
Looking for a way to visualize my data in an easier way. Love how I can create trend lines for others to look at in Excel. Would love to have this feature in Smartsheet.
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,