-
Assigning Team Memebers to Task/Duration
Let say you have a task with a set duration, start and end date. The duration was based on 1 person doing the work but if I want to assign it to 4 people so it theoretically goes 4 times faster. Is there a way to say to smartsheet "This task has 4 people working on it" and for smartsheet to then adjust the duration, start…
-
Organize Worksheets
Is there a way to organize Workspaces? I've got a lot of Workspaces and they are in no kind of order. They seem to just be randomly saved with no rhyme or reason to the order in which they are saved. Would LOVE for there to be a way organize them like you can emails.
-
Attaching URL's to Each Row - Is there an option to have them available for the entire sheet???
Hello, When a new row is added to my sheet, I have 3 url links that I need to attach to the row. I can then "SEND" the row back to the requestor with the authorization and the URL links for them for reference. Currently I have to copy/paste these URL's to EACH ROW....is there a way that I can have these 3 URL links…
-
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
-
incorporating map in smartshint printout
Is there a way to bring a smartsheet map into the sheet itself to print? It would be very useful (not to mention extremely professional looking) to be able to print the sheet with the map on one page.
-
Interconnecting sheets/data?
We are evaluating Smartsheet as a Project Management solution. I'm wondering if it's possible to have a sheet for "Client Contact List" and then a "Project Management" sheet that can reference it. For instance, could I create a column called "Contact" and select from my contacts and have it auto-populate other columns such…
-
Row properties
Is there a way to apply "row properties", similar to "column properties"? I have an analysis that has customer listed across the top and the rows are the critieria with which they are being evaluated. I'd rather scroll down than across.
-
Linked Resource Allocation Overview Sheet
I'm trying to create an automatically updated linked overview sheet to help my team to better visualize how their task assignements on various projects sometimes overlap. The resource views provided by the Smartsheet Resource view are just not that easy for the team members to parse and so they never use it... The "angry…
-
i am trying to set up an It Service Request Tracker - Need workflow approval
Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. Can that be done?
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.