I’m trying to debug a fairly complicated DateTime formula.
But finding it impossible due to the way Appsheet handles virtual columns.
I’m getting totally different answers depending on whether I look at them in the Detail view or Form view.
When I click on TEST for the formula it seems to match the Detail view.
Also, I’m not certain, but it looks like some of the Detail view columns are reading the Form view columns and vice-versa
I have a VC called [Est Time] with the following formula: TIME(“09:00:00”+[Time on Last Day]) = 18:26:57 where [Time on last day]=“01:26:58” and is a DURATION.
So its wrong as the result should be 10:26:58
I even tried TIME(TIME(“09:00:00”)+[Time on Last Day]) but the result is the same
Yet in Form view, the answer is correct, “10:26:xx”
Weirder still, I also calculate [Est Date].
This is correct in the Detail view and wrong in the Form view.
The opposite of the above