Formulas to durations or equivalent

I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output.

My problem is Smartsheet won't allow durations to be edited by way of a formula.

Also I am wanting the variables to be as follows:

Completion Date - Constant (fixed) Variable

Duration - Dependant Variable (dependant on formula input)

Start Date - Output (calculated backwards, completion date less the duration)

I can quite easily achieve this by disabling dependencies however I need dependencies to include and programme sub-deliverable and subsequent tasks.

If you wish to contact please send to huxley@apollofabrication.com.au not to accounts.

Thanks,

Huxley

Find more posts tagged with

Manufacturing

Construction

Formulas

IT & Operations

Gantt View

Project Management

Comments

Taylor F

Hello Huxley,

You are correct that there isn't a way to use a formula in a Dependency column such as Duration.

This is due to the fact that the Duration column is using a formula itself to calculate the duration between the Start Date and End Date and can't support an additional formula.

I've added your vote for this to our enhancement request list for our Product Team to consider for future development.

Regards,

Taylor

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?