-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
-
Mandatory Comment on Approval Form.
Hello, How can we make the comment section in the Approval Form mandatory? like it is mandatory no matter what.
-
Print Baseline
Currently there is no option to add the baseline when printing- upon research it seems that for some reason this isn't an option. Can we get an option to add the baseline when printing?
-
Annotation
Often when doing a delay analysis or some other schedule work, we need to annotate the Gantt chart to highlight certain areas, add notes etc to give the data more impact. Currently this has to be done in another program like PDF, can Smartsheet make such an option available?
-
Visually demonstrate delay
When doing presentations its critical to be able to visually communicate delay. Currently in Smartsheet we can turn on the baseline to see planned vs actual however it is very limited i.e no ability to change the colour of the baseline, show durations of delay with an arrow etc. To be able to compare activities from one…
-
Total number of days a resource has been allocated
I’m working on a project with multi resources. Is it possible to run a report that shows the total number of days a resource has been allocated? So, I can calculate the work effort against a resources? Thank you
-
Programme Status based on %complete
Hi There, Apologies if this has been addressed elsewhere, I could not find anything similar. Are you able to status update a programme so to update % complete and the resequence the programme task to start after the today line?
-
Document Control Using Smartsheets
@Chris Mondeau thank you for your help in my original post. I thought I would re-post here for everyone else within the industry could share. Hi Team, I work in the construction industry as a joiner and as part my day to day, I received architectural plans. Is there a way to set up a Smartsheet as a Document Control…
-
creating mid-task lag?
In construction scheduling, we often have weather delays, lag when subs are working out of town, etc in which we need to create a delay mid-task. i.e., contractor A starts a task on 1/2, is delayed until 1/9 due to cold weather than picks back up and completes the task 7 days later than originally anticipated. Is there a…
-
RFI Request for Information Template - can not find
I found the RFI Request for Information Template that I loved on Google so I signed up for a Smart Sheet account. Im logged in and search for RFI Request for Information Template- the search result is a "Status View Smart Sheet" not a RFI Template. See screen shot. Here is a link to reference page to RFI Request for…