How to enter a formula referencing other cells within Duration?

Hello,

I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the duration cells. Any idea why and how I would accomplish this?

Thank you!

Find more posts tagged with

Formulas

Project Management

Comments

Paul Newcome

Being able to use formulas for a dependency column (date, duration, predecessor) is something I have been trying to accomplish for a while now. Hopefully someone is able to figure out a workaround...

Gordon

Similar request, except that I have a "Total Budget" numeric column that summarizes the total of budgeted hours for a task across three different team members, and I would like to use the total budgeted hours for the duration to auto-calculate the end date, and thus manage if my milestones/deadlines will be achieved, as the budget amounts change.

Andrée Starå

Hi Gordon,

Can you share the sheet or some screenshots so I can get a better understanding of your set up?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Gordon

Sure, please see attached/below. Basically, this is a standard, dependencies-enabled project sheet. The total budget column is a numeric column that is the sum of three numeric columns to the right and represents the total budgeted time in hours for that row's task on the project. I'd like to use that total amount (in hours) for the duration, such that the end date is auto-calculated by Smartsheet. The duration in the screenshot right now is manually keyed in to match the total column.

My objective is to see how our budgeted time estimates and start dates will impact the ability for the project to meet the project's deadline, using smartsheet's dependencies and key-path functionality. This would seem to be a standard type of feature for any project management system, yet I cannot figure out how to get it to work.

Andrée Starå

Ok.

Unfortunately, it's not possible at the moment because you can't have any formulas in the Duration column when dependencies are enabled, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

I hope this helps you!

Have a fantastic week!

Best,

Andrée

justinlicameli

Has this feature been implemented yet?

Sign in to join the conversation!

Quick Links

Trending discussions

Auto Fill Date When Column Checked
I want my date column to auto fill when I check the column Verification and Closure. What formula do I use? I want to ensure that the date doesn't change as time goes on.
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…