PROJECT DURATION - OVERIDE DEFAULT
I use a smartsheet to manage engineering tasks
I have columns that calculate task duration based on work types
I now want to convert this to a project sheet and have the task duration driven by an existing column
Example: I would like my "Planned Hrs" column to determine the task duration
Does anyone know how to have the Duration column get the value I have in another column?
Mike
Comments
-
You would go into the project settings and adjust which column the duration is running from.
-
To get to project settings right click on any column header and project settings will be an option in the dropdown.
-
Thanks for the answers to my query.
I will try these solutions
-
Paul,
I change the Duration setting to my column (Hours Remaining)
It did what you said but it automatically changed my data from Hrs to Days which means my Gantt chart is now way over stated
Example: 3.012 became 3.012d
-
Hi Mike,
You'll have to write it like 1h 30m.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree's response is correct. Give that a try and let us know.
-
Thanks everyone for the input.
I thought I might show what I am trying to achieve
I am wanting to use my task sheet to schedule tasks
I have 5 engineers with multiple tasks in front of them, and always new task added wanted 2 days ago :-)
The task priorities change often so I was looking to use Gantt View with my sheet set as a project sheet
The task sheet works well at the moment but is limited to a list, with a due by Date
I have several columns which calculate the "Planned Hours" for each row (Task) based on the type and complexity of the work
I had planned to use the Planned Hours to set the duration and hoped to set the "Complete Date based on when it is required to be finished, letting the start date be driven by the Planned hour and the Complete date
A lot of the tasks have a planed Hours under 1 day, and there is where I seem to run into trouble
See if the attached image makes it clear what I am trying to achieve
-
Unfortunately the biggest hitch in your system is that we currently cannot use formulas in dependency columns including duration. It would be a really great feature though, so feel free to submit a Product Enhancement Request.
-
Hi Paul,
Thanks for your response, I have sent off a product enhancement request
"Formulas in dependency columns including duration"
-
Anyone got any ideas for a workaround?
I have attached another screenshot of my sheet
-
Andree or someone with more experience would need to confirm as I am not very familiar with the API, but I feel like there could be a way to automatically read the data in a cell and then insert said data into another cell on the same row either through the API or a 3rd party app such as Zapier.
If that is possible, then you could have your Planned Hours column working up your calculations and then use either the API or Zapier to pull from that column and insert into the Duration column.
Again... I am not very familiar with either of those. Just kind of throwing out some ideas at his point.
Aside from the above... All I can think of (for now) is to keep your Planned Hours column calculating and then manually enter the result into the duration column.
-
Thanks Again for your input Paul.
I am thinking the same at the moment.
Manually enter the planned hours into duration. This will at least test the theory of what I am trying to achieve for now and then I can look to automate
-
Happy to help (sort of)!
The easiest way I can think of for manual input is to work everything else out first then copy/paste the entire column over. It will pull the value but not the formula. That should help save you from having to manually enter a ton of additional data.
-
Yes, it's probably possible with Zapier or the Smartheet API, but I'd have to check to be sure.
@Mike, Let me know if Pauls method is sufficient or not.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives