Change task Duration based on a condition in another cell

Hello Everyone.

The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work...

I am using a standard sheet template which I also use to forecast,

I would like to change the 'duration' of a set of tasks based on a dropdown that would return 'Small', 'Medium' and 'Large' so that I can maintain one template.

It would seem that I cannot put a formula inside the duration column... is there a formula that I could use that could add / update / insert the correct duration based on the condition found in the dropdown?

Thanks.

Find more posts tagged with

Templates

Sheets

Formulas

IT & Operations

Gantt View

Project Management

Comments

Mick Jordan

HI, I think your options here are fairly limited. eg:-

1) Use 3 different templates

2) Have the 3 different variants of project task durations stored in seperate columns which can be quickly copied across when you initiate the project.

3) Employ a small app that uses the Smartsheet API to mechanise the approach. eg a desktop form that appears where you enter the name of the new project, the variant (ie which of the 3 types) and any other attributes eg folder/workspace name. At the click of a button the new Smartsheet would be created with the appropriate durations.

Mick

Mr.Hyde

Thanks for those suggestions Mick and taking the time to consider my request.

I don't think I have the time or inclination to create an app to trump option 2 ;-) Its a shame that the Smartsheet form is not yet flexible enough to insert into specific cells, otherwise that might have been an option for the type of solution you describe.

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.