External data link overwrites formulas

External data link overwrites formulas

I have data being imported from a google spreadsheet. When it is imported into zoho, either manually or auto refresh it inserts a blank cell where i had a formula. 

A very very simple example of what i mean would be:

Data is being received into column A.  Then column B uses a formula to show same info.

      A                 B                
1  test              test         (formula would be ... =a1
2  test2            test2        (formula would be ... =a2

When data is updated from external sheet, when I receive "test3" into cell A3, the formula in B3 disappears or is moved.
I don't want it to move !!