4

Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base.  In that sheet I have a  column (RYG balls) with a formula to calculate overdue estimates.  But every time that I import the new data, that column is crushed.  I even added it at the far end beyond the imported data parameter.  Is there a way to protect that column from being crushed?

Thanks

Functionality
Sheets
Industry
Other
Department
Other

Comments

Andree_Stara

Hi,

How do you import the information?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. 

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Have you tried just copying and pasting the data - minus the columns that have formulas?

Andree_Stara

Another way could be to import and then move the rows to the main sheet.

Would that work?

Best,

Andrée

Can you elaborate on what you mean by "column is crushed" ?