L
L
Leskom2022-03-28 18:59:30
Google Sheets
Leskom, 2022-03-28 18:59:30

How to automatically copy cell contents when data is changed with importxml?

There is a table that collects service rates from different sites via importxml. The problem is that quite a lot of data is collected, often "loading" hangs in the cells and further actions with the calculations are impossible. To get around this, I made an additional column with reserve values ​​and tied all formulas to it. Is it possible to make it so that if some tariff changes on the pages, then the new data would be automatically copied to the backup cell? In this case, if the cell is "loading", then this text is not copied. There is also one tariff where you need to cut off the letters, they say "from 157", so that only "157" is copied.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2022-03-31
@Leskom

Make getting data a function and put it in a time trigger or whatever.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question