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

[Tim_Bourn]

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

[Marc_Dillon]

I think you probably just need to change

Export Inbound Operations[DOCK]

to just

[DOCK]

And the same in the other expression.

---

Expressions of the form:

Table[Column]

returns a List of ALL values in the column of the entire table.

[Tim_Bourn]

Legend,

Thank you