Forum Discussion
Value not shown in grid but shown in edit window.
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.
Hi michalkornet and thank you so much!
This did the trick for the first few affected columns I've tried, so expect it will sort them all out.
Any clues as to what would have made this suddenly become a problem?
Cheers!
Mark.
