I have made a few differents options for days pending with SharePoint. I would like to know, how many days a item is open.
First i tried this solution: https://www.solwebsolutions.com/blog/entry/calculate-age-of-sharepoint-list-items I tried this solution, i deleted the today columns. After this, "SharePoint automatically refers "Today" (which has been deleted now) as the today’s date in the formula calculation." but that don't work.
Second option: =DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy")) Days since list item was created
Both option dont update the item by them self. Do you know why it don't work? I tested both option on two differents tenants.
Hopefully we can fix this :)