-
Is there a way to make my folder structure setup the default for everyone on our account?
Thinking of this like file explorer so that all of the sheets are organized rather than in one long list for the users I add / share sheets to throughout the team. thanks
-
Changing Duration to Hours changes my Finish time
Hi all, I am having a problem that needs your assistance. Most of our projects are done in hours over a number of days. I have changed the Duration to hours instead of days in my sheet but what it then does is change the Finish time. How have you corrected this? Your assistance would be greatly appreciated
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
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…
