Hello, I added an external link to a csv file and enabled the update every 60 seconds option.
Then I applied some styles in the table view.
But every time the link updates I loose the formating. How to fix that?
One way I found is:
- import CSV as ‘External Link’ into a sheet (sheet1)
- create a second sheet (sheet2) that reads values from sheet1
formula:=IF(ISBLANK($sheet1.A1);"";$sheet1.A1) - add styles in sheet2
Optional:
- hide sheet1
In this way, it looks like the External link was styled (workaround way), and after sheet1 refreshes, sheet2 styles are kept.