Problems with static values in sharepoint list – possible workaround with JSON??
I have a list of changes in sharepoint , each change is an entry. I have a current week view and a next week view for the change management list. These are filtered by week number of the chnage, as if i used a range of between eg 7 – 14 days, if i were to look at the list on a friday it would miss out the changes for the following monday in my next week view. It seemingly works but at the beginning of each week it doesnt refresh unless i make a small change, save , then revert the change in list settings, or if i add a new entry.
I went through several Microsoft community posts and they all say that calculated values (based on content of another columns) are only updated if
the item/list entry is createdthe item/list entry is modifiedthe whole view or cloumn is modified
I was advised I could try playing around with JSON formatting to display the content of the other columns, instead of using calculated columns, but not sure where to start/how to go about it. I will inlude screenshots of what I have in my sharepoint list
I have a list of changes in sharepoint , each change is an entry. I have a current week view and a next week view for the change management list. These are filtered by week number of the chnage, as if i used a range of between eg 7 – 14 days, if i were to look at the list on a friday it would miss out the changes for the following monday in my next week view. It seemingly works but at the beginning of each week it doesnt refresh unless i make a small change, save , then revert the change in list settings, or if i add a new entry. I went through several Microsoft community posts and they all say that calculated values (based on content of another columns) are only updated ifthe item/list entry is createdthe item/list entry is modifiedthe whole view or cloumn is modified I was advised I could try playing around with JSON formatting to display the content of the other columns, instead of using calculated columns, but not sure where to start/how to go about it. I will inlude screenshots of what I have in my sharepoint list Read More