CSV file blank cells are returning a time / number when uploading to appsheet

Hi Community,

Thanks in advanced for your help.

I have an action to upload a CSV file to my data source. In my CSV file i have a column called “Gate Entry”. This is blank in the upload file as the user will update this when the vehicle arrives. However appsheet is converting the black cells into a UTC time i,e 2:34am. I want this to remain blank.

My current app formula is IF(ISNOTBLANK(Export Inbound Operations[DOCK]),TIMENOW(),"")
In the upload file dock is also blank. I then want time TIMENOW() to trigger once a dock has been entered by the user. The above is happening to 4 columns all of these columns have an app formula to return TIMENOW() or IF(ISNOTBLANK(Export Inbound Operations[Operator Name]),HOUR([Finish]-[Gate Entry])*60+MINUTE([Finish]-[Gate Entry]),"")

Thank you

0 2 150
2 REPLIES 2
Top Labels in this Space