Forum Discussion

MyQueries's avatar
MyQueries
Copper Contributor
Apr 25, 2023

Aging Calculation based on Condition

Hi All,   I have created a SharePoint list where I want to calculate the aging of tickets in days based on Status of ticket. I have created the custom formula as well for this but somehow its how s...
Lists
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP
Apr 25, 2023

MyQueries Your formula syntax seems fine to me. Try using NOW() instead of TODAY() once.

 

Also, you can try using Text function instead of DATEDIF function like: 

 

=TEXT([Column2]-[Column1],"dd")

Note: Calculated column values will be updated only when item is created/modified or when calculated formula itself is updated.

 

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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

MyQueries's avatar
MyQueries
Copper Contributor
Apr 25, 2023

ganeshsanap 

 

Thank you for your comments. Is there any way using flow or other option so that calculated filed automatically update as compare to current date and until status changed to "completed" ? 

 

 

Resources