Forum Discussion

Matthew Carter's avatar
Matthew Carter
Iron Contributor
Dec 10, 2021

SPO Calculated Column not updating date

Hello, I am in SharePoint Online and I have a modern Lists list. I have a calculated column "Alert Age" which uses the Calculated column of number.   =TEXT(DATEDIF([Date Reported],TODAY(),"d"),"#"...
Lists
microsoft lists
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Dec 12, 2021

Matthew Carter Calculated column values are calculated & updated only when:

  • A new item is created
  • An existing item is updated
  • Calculated column formula is updated

So, using Today() in formula does not update the value on daily basis.

 

Check this thread for more information: Count not updating in calculated column 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Mar 24, 2023

    sahilpathania Can you start a new discussion and provide more details about your requirements. 

    Also, include the formula you have tried in your discussion/question.

    Please consider giving a Like if my post helped you in any way. For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources