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:

​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:   Read More

​