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 !!