-
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…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
What does the little blue man icon in sharing mean?
Hi, What does the little blue man icon in sharing mean? Its on some but not others, see the little attached picture thanks
-
Where can I put completed, abandoned, or inactive Workspaces?
We have completed projects, or abandoned projects, with Workspaces. We don't want to lose them, or archive them to Excel - especially since the abandoned projects could come back to life one day. The problem is we have so many workspaces, the inactive workspaces are junking up the folder list. Is there anyway to create a…
-
Dynamic Sum from Multiple Sheets in a Workspace
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like…
