Why is AppSheet not syncing correctly with my...

[Brady_Lovell]

Why is AppSheet not syncing correctly with my gSheet when using this formula to get live weather?

=transpose(IMPORTHTML(“https://www.accuweather.com/en/us/dade-city-fl/33523/hourly-weather-forecast/332333","table”,1))

I have 6 locations that I need live weather updates. I created a gSheet called Weather. I then created 6 workSheets and labeled them ‘Location 1’, ‘Location 2’, ‘Location 3’, etc…In cell A1 of each workSheet, I enter the above mentioned formula, which populates each workSheet with an hourly forecast.

I then go into AppSheet and import the 6 tables. I then create 6 ‘Ref’ Views. Then I created a ‘Dashboard’ View to display all 6 of my ‘Ref’ Views.

Everything looks and works beautifully, but it’s not updating. Currently (7pm), my gSheet weather is correct and is displaying hourly time starting at 6pm - 1am. But when I open AppSheet, the weather is still reading 1am - 8am, which would of been the forecast for late last night and into this morning.

Any ideas on what’s going on? I am pretty sure I’ve gone through everything but just can’t seem to figure it out. I’ve synced and refreshed until my fingers are numb, and still nothing. Any and all suggestions are greatly appreciated!

Thanks