Template and use of formulas

Shawn Borror

I am using a project plan template and have some formulas on the Health prebuilt - however if someonee adds another task via insert (which they should be able to do) it does not carry/maintain the formula on the newly added Health column. Please advise.

Andrée Starå

Hi Shawn,

What’s the formula?

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

If there are two rows above and/or below with the formula and of the same hierarchy, then the formula should be auto-filling as soon as you enter data in another column of that new row.

Shawn Borror

Got it - it was b/c my tasks were blank the cells had formulas so it didn't copy the formula down. When I added task names and then inserted new row - the formulas were carried through.

Andrée Starå

Hi Shawn,

What’s the formula?

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

If there are two rows above and/or below with the formula and of the same hierarchy, then the formula should be auto-filling as soon as you enter data in another column of that new row.

Shawn Borror

Got it - it was b/c my tasks were blank the cells had formulas so it didn't copy the formula down. When I added task names and then inserted new row - the formulas were carried through.

Paul Newcome

Glad you got it figured out.