If then formula - word in one column = number in another column

TullyONeill

Hi working on a work breakdown schedule and need if then qualifiers.

Idea is if the word "Design" is in the column "Who Produces the piece? (image below)

Automatically add "2" in the duration column in the row that has the copy "execute piece changes" under "task type" column.

Paul Newcome

If you are using the dependencies in the sheet, you will not be able to use a formula to populate the duration column.

TullyONeill

Thanks for the help Paul! Is there anyway I can make this work? Perhaps via automation?

Paul Newcome

You may be able to use the API or the premium add-on Bridge, but Automations cannot change dependency driven columns either.