Auto Update returns #DIV/0!

Hi,

thanks for your post, and sorry for the trouble.

TablePress does not understand or support external sheets, which is likely the cause why these formulas break.
Just to be sure: What are you seeing on the “Edit” screen of the table? That exact formula (including the reference to the other worksheet)?

Regards,
Tobias

Hello,
I don’t use formulas in the TablePress itself, I just set the table to refresh using the TablePress automatic plugin and data from my Google Sheets

Here’s what I do
1. I create a table in Google Sheets
2. I create worksheet with =ImportJSON(“http:…….json”, “/”, “noInherit,noTruncate,noPrefixHeaders”, doNotDelete!$A$1)
3. Everything is updated regularly through a script
4. After that I make another worksheet and put this formula

=12.5*(1440/2.5)*(B2*1000/allCountriesCases!O2)
where allCountriesCases!O2 is cell with the JSON data from 1st worksheet

5. Everything looks/work fine on Google sheets and the above formula return calculated number – so far so good ??
6. Then I download the google sheets table as .CSV and I import the table on the TablePress
7. Everything looks the same like Google Sheets

8. Then I activate Auto Update on TablePress (I know how to use this, because I don’n have problem with other tables which used auto update) and when the table is updated automatically the data on the cell with the formula (B2*1000/allCountriesCases!O2) shows #DIV/0

Here is the google sheets – https://docs.google.com/spreadsheets/d/1eCZv-Kd4JI9ZczL-YJ3VJt0t5tLDbowEODPJjwpNBk4/edit?usp=sharing
Just ask for permission! I will give you permission to edit one the table is open.

Please use tablepress.org email to know it’s you

Thank you!

• This reply was modified 2 years, 4 months ago by silenceworld.

Hi,

from the perspective of TablePress, only the URL that you use in the Auto Import really matters. Can you maybe share that? I’m pretty sure that it already contains those #DIV/0 entries, which means that there’s nothing really that TablePress can do about this.

To confirm: Are these #DIV/0 entries already visible on the table’s “Edit” screen after importing?

Regards,
Tobias

Hi,

Yes! #DIV/0! is visible in the TablePress cells when I open the tablepress to edit it on the WP website, but I can’t figure out why when I open the table through HTML everything looks fine.

I will do some further research and let you know if I find a solution.

Hi,

ok, this indeed means that Google Spreadsheets is already giving this result then, so that there’s nothing that TablePress can do here ?? Sorry.
You would need to find an export URL that directly returns the proper calculated result.

Regards,
Tobias