-
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Report vs workspace permissions
Hi all, can someone please verify whether the workspace-level permissions override the sheet or report-level permissions? For example, I have a user I'd like to have Viewer permission on the overall workspace but Editor permission on a specific report. He has Editor permission on the underlying source sheet (located…
-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
I can't find my work!
hello, I am new to smartsheets and I am trying it out for 30days. I did some work on an imported spreadsheet and thought that I saved it but signing into my account today I can't find the work! what "open" brings up are the workspaces with only new rows available. Please help!
-
When adding a collaborator to a sheet in a workspace, does the message get sent to just them, or eve
When adding a collaborator to a sheet in a workspace, and I choose to provide a message with it, does the message get sent to just the person I'm adding, or to everyone in the workspace? I have searched and have not been able to find a solid answer to this. I ask because when sharing a sheet in a workspace, there is a…
-
Formula TO NOT have to manully enter formula for every row
Good morning, Looking for some help on this issue. We have a sheet with hundreds of rows that tally up to a total (1049.86 hours per below JPEG) We need to calculate the % each piece is from the total . These are the children rows. The first formula I got to work by using =SUM([Total Hours Per Peice]42 / ([Total Hours Per…
-
Updating Sheets
Hi everyone. i have a sheet where all entries are made via a form. all of the users with access to the sheet are "Editors, can/can not share". Today they attempted to add or change data to a line and save. when they went back into the sheet, the changes were not made. Any idea what is going on? I am the sheet owner and can…
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
-
Transferring Workspaces
I've had my intern create 168 workspaces, with each workspace containing approximately 20-50 sheets each, organized into various folders under each workspace. Each workspace also has 3-4 dashboards pulling together this information... With my intern leaving at the end of next week, what is the easiest way to bulk transfer…
