-
Ideas on how to handle complex projects with LOTS of sub-tasks
I am working with on of our departments internally on their Smartsheet system, and looking for insight into how some of you handle complex project plans. What they have right now is so bloated that it is unmanageable, and making them rethink using Smartsheet as a system at all. for context, they went from using Google…
-
Merged: Sheet Name URL in DV
This discussion has been merged.
-
Is there a way to use Automation to update a Duration column?
I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?
-
Latest Comment column disconnected, still not able to create new or recreate
I followed the process in the post "Can't select Latest Comment in the edit column properties", disconnected the Latest Comment, Saved/Refreshed, renamed original Latest Comment column, refreshed again, then Inserted Latest Comment (via comment ellipses). It created the Latest Column column but it's not marking it as…
-
How to get project overall delay in days in Smartsheet
Hi While we use the Baselines on the task level to see the delays per task, is there a way to grab the overall project delay in days and also show it in the Dashboard? Thanks for any prompt Regards /Marat
-
Calculate Start Date from Project End Date
I'm trying to perform what I believe should be a very easy task. I need to enter the end date of an activity and have the preceding activities populate their dates. I'm assuming this is possible if the durations and predecessors are populated, but when I enter the end date and hit enter, it resets to null. Can I calculate…
-
Why is my percent complete not updating?
I have a project plan which pulls in data from a other referenced sheet. We track our development in a tracker, and have a dashboard and reports that help us understand where we are with progress for development. The percent complete pulls in automatically from a reference sheet into SubTasks in the project plan. However,…
-
Resource Management and Project plan
I'm trying to wrap my ahead around using RM and how the project plan incorporates into it. Are there templates that work best with RM? I also wanted to know if the change mades in the schedule in RM will appear and reflect on the project plan automatically?
-
Do I really have to make the same change on every single one of my sheets separately?
Hi Folks - I'm pretty much a newbie to SS, but I have already created 20+ different sheets for each of my projects, using a template. Now, if I want to make a change to the structure of all the sheets (ie, change the name of a column, add an alert, or anything really!)… is there not a way to automatically make the same…
-
Need Ideas: How best to organize staff times
We regularly have requests for staff to cover orals or sales meetings. The 'areas' for the staff are consistent (e.g., HR, Payroll, Financials, Technical, etc.), but then for each 'date' there may be a request for HR to be onsite, Payroll to remote - and then we need an indication of which role is needed for which areas…
