Add lines in templates and have the formulas auto appear

Ann@WeVeel

Hi,

So I created this template for our sales team. The idea is that in the yellow boxes they enter item number and quantity (and other things based on where they are in the template) and was informed that there are some sales orders where they will need to add additional boxes.



We were looking to have it set up so that one person in the department has a license and can open the template for the 3 sales people who ideally will have the unlicensed free accounts.

In this template, I have the cells locked that cannot be edited. Generally, they are a mess of formulas and people don’t need to go messing with the formulas and all the dependent linked cells.

So the problem I’m having is that when I add a line in the middle of the formula block it does not add all the formulas automatically (like in excel).  

Is there a way to add a line and automatically have the formulas populate?

Thanks a bunch!

Andrée Starå

Hi Ann,

Are you using Parents/children? When you add a row is it added as a child?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Ann@WeVeel

I am not using Parent/Child. These are straight rows.

 

Thanks

Andrée Starå

Then it should work. Are you adding any information to the row?

Best,

Andrée

Ann@WeVeel

What do you mean?

I tried adding in parent/child  and it still didn't work. I added a row in to test it

 

Please see in this screen shot where line 12 is not the same colors or have the arrows that cells from other sheets are linked.

Ann@WeVeel

additionally here is the shot without the parent/child

Andrée Starå

If you change the color manually or add a character it will probably ”activate” the row.

Did it work?

Best,

Andrée 

Ann@WeVeel

YES! Typing in the next number in the sequins activated the row.

Thank you!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée