Expression result appears in the virtual column but not in the normal column

[Khaled_Ibrahim]

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

• I make my changes throw the form
• I don’t need that virtual column in my project because I need to save data in the spreadsheet