Forum Discussion
Value not shown in grid but shown in edit window.
Hi all, I seek you advise, I have a calculated column in date format. For some reasons I don't get the result in the grid view. However it is in the edit window If I change col...
Seems that it was more difficult than expected as many views and no answer 🤔
Same issue as Larry_Lux_57 , just started happening today. Other Lists on same site with similar columns are still displaying ok. It's like anything related to dates or date calcs is failing to show in grid, but like OP the values are there in the edit form.
A few more things I've discovered:
- The other List I mentioned IS now affected in the same way
- If I create a new blank List, and add a calculated column returning a date, with a simple formula like "=[Created]", the result fails to show. Change the return type to text, and it does show (as another poster noted)
- The dates are still there on export to Excel (as another poster noted)
- Onward calculation is still ok: e.g. with a working days calc using some calculated date columns. Though the dates (for affected columns) do not show in the grid, the calc still works if the output is a number.
Hi MarkDavis385,
thank you for the steps to reproduce the error. I was able to see the same problem with the calculated column.
As I mentioned in the previous post, it looks like a problem with the default column formatting for calculated columns.
This simple column formatting will resolve the problem.
{"elmType": "div","txtContent": "@currentField"}- You legend(s)! Thank you so much. I added this code to the Column Formatting via 'Advanced Mode' and all working perfect again. Much appreciated.
