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 column type from 'Date and Time' Date only to single line of text; then it is displayed in grid but as a number like 45517.
Why is it not showing when it is a date ???
Thanks
- 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 there, I am having this exact problem right now and it makes no sense. I have a Power Automate flow that grabs an email with specific Subject criteria and creates a Sharepoint List item, then it populates another column (in same row item) using a calculated field formula to add 14 days. It has worked perfect up until today. I can see the calculated date field everywhere except the Grid (list) view. When I open the individual items, its there. When I download to Excel, its there. But it has completely gone from Grid view. I'm glad its not just me!
Hi Larry_Lux_57 , I had a similar case with a different column type. In my case, I changed the type of the column after some time, and the result in the grid disappeared. I noticed that the column formatting was still related to the previous column type. When I removed the column formatting, everything was okay.
Maybe it's the same case in your situation.
