Formula Management

Copper Contributor

I have a spreadsheet with hidden columns including formulas to calculate dates (project schedule).  When I insert a row in the middle of the data I would like it to automatically populate the hidden columns with formulas as above and/or below it.  Is this possible?

2 Replies

@deanlevey

 

Hi,

 

To get that, you have to convert the data to Table.

Please check out this link to learn more.

 

Regards

@Haytham Amairah Thank you so much for that!  worked perfectly.