-
Header
I want to add a fixed header that displays above rows on my sheet. I see this is available when printing the sheet, but I need to add instructions and clarification to the published sheet that is viewable by collaborators.
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
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…