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 dur…
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 th…
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 e…
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 affec…
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 su…
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 ca…
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.
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…
Smartsheet should add a standard column. Initally it includes a button syaing "start". When pressured on, a clock starts running in the background and keeps on running until one press the same button …
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a busines…
