Strange data display in concatenated date field

I have a field with an app formula that is suddenly not displaying correctly even though the data is being stored correctly in the underlying sheet. I don’t think I changed anything.

Old data displays properly. Today’s data does not. Instead of Jul 23 it shows 44400

3X_6_f_6fc1243a2dd331efc319e7956ee5b8ce969d0674.png

This is the app formula. It correctly formats the date in the underlying data.

The underlying data is correct but is not displaying correctly.
3X_3_c_3cee12e75a0165bd2ddb55b151eed5343a86356a.png

Any ideas?

Update. When it first processes it shows the correct format. THEN it switches to 44400. I have a video of that but don’t think I can upload it.

Solved Solved
1 2 219
1 ACCEPTED SOLUTION

Try changing the format to text in your google sheets.

View solution in original post

2 REPLIES 2
Top Labels in this Space