User Profile
LearningSharepoint
Copper Contributor
Joined 3 months ago
User Widgets
Recent Discussions
JSON Code not working when calculating Days Since Received
I am hoping to use a Microsoft List to manage a team's files. I originally used the following code in my "Days Since Received" column, however, I later learned that this formula would not automatically (dynamically?) update after noticing that the days within the column never changed after being entered: =TODAY()-[Received (date)] To rectify this, I found a suggestion on the internet to use a JSON code to try and make it so the MS List automatically updates each day on its own. Unfortunately I am receiving the following error in the Days Since Received column: =floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12) The JSON I am using is as follows: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12)" } I am unsure what's going wrong. This is how I've set it up:
