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...
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.
