How to update the formula?

M

Mr.2020-09-19 22:42:32

Google Sheets

Mr., 2020-09-19 22:42:32

When reading formulas, it sometimes happens to me that the formula was not executed and gave the #N / A error, and in order for it to be updated, I have to wait for days until its turn comes. Maybe. Is there a way to update only the required formula? I tried to just delete and paste it, but it still gives an error. And even if the error disappears, the error appears in another formula.
Spreadsheet link
https://docs.google.com/spreadsheets/d/13lzkFlnGGB...

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

mityayka1, 2020-09-20
@mityayka1

Most likely these are formulas like importXML
You can solve this problem through an if and a checkbox. And turning off-turning on the flag to update the formula.