-
Roll-up distinct selections in dropdown to parent row
Is there a way to roll-up child dropdown selections to the parent row so that the selections show only once in the parent? Example: Dropdown contains: Red, Blue, Yellow Child 1 selects Red Child 2 selects Yellow Child 3 selects Red I found where I can use JOIN(Children()), but this will display Red, Yellow, Red in the…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
-
Change Request - Remove ability to edit filters.....
For users of <user - can't share> level permission, turn off their ability to modify / duplicate filters on sheets that have been shared to them. The filters I give them with a sheet are the filters I want them to use, no other! The minute they see that they can duplicate / change filters our workflow is hosed. You are on…
-
Timesaving Features - Please!
1. When in Admin mode, ability to actually lock rows and columns on the sheet you are working on. Lackcing this, we throw away one seat on the three user system as we use Admin exclusively for programming, building filters and administrating the Workspaces. 2. Double click on format painter holdls the sample in memory…
-
Autonumber refresh for new year
I use a formatted autonumber column to record a new Reference Number for each new entry in a Smartsheet. The format I use is CR{YY}.000 where 000 started from 001 for the year 2016. I want to continue this format into 2017, but I want the 000 to restart from 001. Any thoughts ? My list of rows should end up like : CR16.001…
-
Update Webform URL's included in Folder when Save As New used
We are currently running multiple Projects and have setup a Master Folder with our Process Task lists in using Card View. Within Card View we have links to some Webforms used to capture Data for certain key tasks. The Webform sheets are located in the same folder. When we do Save As New using the Master Folder to Create a…
-
Hiding data in my project plan for specific users
Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…
-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
