I have an excel formula which is an array formula that looks up if the date is less than or equal to today(). If so it makes the result 0. If not then for the first record it pulls the current bank balance and deducts the first transaction. It then continues down the list removing transactions from the previous cells balance and creates a running sum.
It works great in Excel and appsheet however it seems to be using US time so the date until about halfway through the day is the previous day since the US is 12 hours behind Australia.
This means my app only works in the afternoon which is annoying.
If I use Today() in Appsheet in a virtual column it returns the correct day. If I have a field in Excel with just Today() in it then I get the day in the US.
I have set the table Locale to English (Australia).
The excel formula is:
This translates to the following in Appsheet
This all seems correct.