-
Google Form to Smartsheets Sync (Update data)
If I have a form already created, and a user wants to update their submission, will that submission that changed the data be synced to Smartsheets or does Sync only work with new submissions?
-
Using Smartsheet data to populate project documents
I looking for opportunities to streamline the production of project updates / documentation by trying work out the best way to use data already captured in various smartsheets to populate project updates to our product development steering group. I presume there is no function in Smartsheets that facilitates the output of…
-
Allocation for Project Manager
We are using Smartsheet with Resource Management enabled. We are tracking % allocation for employees and would like to do so for Leads as well. The idea is that the Lead would be allocated for the duration of task consisting of smaller subtasks at, say, 20%. We are using the Basic Project with Resource Management template.…
-
Recurring sending of a report
We find ourselves needing to send a report on a recurring basis on the 1st & 3rd Friday of each month. However, when there is a 5th Friday, we'd like to have the report sent then, as well. There is the option to send on the last Friday, but that would include sending whenever that's the 4th Friday. Currently, I have to…
-
Template of % of Job Duties assigned, not based on "completed".
Is there a template I can enter staff's job duties to calculate the % of time? Example: Parent would be Office with child of "accounts payable", "mail", "conferences". I would like to enter the % of each child and then have parent be 100%. There would not be a "Completed" % column nor start/end date columns. Thanks.
-
Multiple projects on one sheet
We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if…
-
Access list more than once
I'm in the home building business after I walk a house I make punch list for multiple subs to complete items that pertain to their trade. I have been sending "Send Update Request" to each sub. Some subs might have 10+ items.....they can't remember every item on the first time opened and would like to be able to refer back…
-
when adding a new event to construction spreadsheet start date will not change
i have add some rows to a certain stage in the construction process, however with each new event i add the start date always goes back to the construction start date no matter if i change it on the calendar function or type the date in please help i am using a gantt chart to plot this project out
-
% Complete column can only be updated manually?
Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
-
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with: =IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"") However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion…
