Please help me find the solution to this Appsheet formula problem I am facing.
Iโve two columns with the same expression:
IF([AM]="","",IF([AM]=โOverโ,TOTALHOURS([Work From]-[Clock In]),IF([Execuse AM Value]>TOTALHOURS([Clock In]-[Work From]),"",(TOTALHOURS([Clock In]-[Work From])-[Execuse AM Value]))))
one of the columns is normal from the spreadsheet and the other one is virtual
The problem here is
when I test the expression in each column i have a correct result in the expression result and the virtual column but I have 0 in the normal column
Note that
Check the column definition to make sure there are no settings that would cause rounding or truncation to occur.
For your normal column, is the expression in the App Formula property? If it is in Initial Value, it is only executed when the row is first added and never again.
Have you checked the sheet for actual value saved there?
When you state:
โฆare you making the changes in the same Form for the row where the column โAM Late/Overโ exists and is the column included? For example, if the Form operates on a Slice but the slice does not include the column, the App Formula will not fire for that column.
Thanks for replay
the two columns have the same definition
the sheet save the 0 value as resulted in the normal column
Hmm, I am wondering if you might be impacted by a known issue where the server computes differently than the client/UI side of things. Virtual Columns are computed on the server while your โnormalโ columnsโ App Formula will be computed on the client/UI side.
AppSheet introduced a feature where the server and client use โconsistentโ computation methods. Check the setting shown in the image below. If it is not already set to โConsistentโ, change the setting and try again to see if that fixes it.
Itโs already as shown in your image โฆ I didnโt make any change to this setting
Iโm out of options. I would recommend reaching out to support.
https://www.appsheet.com/Support/Contact
Maybe one last ditch effort is to re-write the expression. I think using the IFS() function is more appropriate than nested IFโs.
Thanks for you
Mr. @Steve could you help me, please
Find an existing row with a blank value in the real column with the App formula, open that row in a form view, make no changes in the form, then click Save. Does the real column with the App formula get a value?
No, it didnโt make any change
I recommend you engage Support for further help with this. Someone there can look directly at your app configuration and troubleshoot.
I would also check the settings of that column in spreadsheet, and also test the formula in initial value
I canโt make the formula in the initial value, my app is changeable continuously
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |