Forum Discussion
Sharepoint list does not group correctly on a calculated field
I have a Sharepoint list with a field "Day", where users enter a date. I have a calculated field, "Week", that finds the week number of "Day". When I group by "Week", the list only shows the first ...
I've created a brand new view - same problem.
I've created a brand new list, with just these 3 fields (title, day, week) - and it works fine!?
On the first list (that doesn't work) I have some Power Automate on top of it. Could that conflict in any way?
Thanks again SvenSieverding
I've created a brand new list, with just these 3 fields (title, day, week) - and it works fine!?
On the first list (that doesn't work) I have some Power Automate on top of it. Could that conflict in any way?
Thanks again SvenSieverding
Hi again
In the list that didn't work, I created a new calculated field "Week Number" and added the formular and created a new list ... and magic ... now it works!
Thanks Sven for pushing me into solution mode as I was giving up 🙂
In the list that didn't work, I created a new calculated field "Week Number" and added the formular and created a new list ... and magic ... now it works!
Thanks Sven for pushing me into solution mode as I was giving up 🙂
- Hi again again
I can see now, that your suggestion on creating a new view will do the job. However, I didn't use the standard view in the first attempt, but based the new view on an existing view, which didn't work.
So creating a new view based on the standard view was the right solution. THANKS!