Forum Discussion
List formula to calculate days since item creation if the item is "pending"?
I have a list configured for users to submit requests.
If a request has not been approved, it will have its 'Status' column set as "pending". I also created a column which is called 'Date Requested', here the user simply inputs the date they added the request.
I need a new column called 'Total Days Pending' with a formula. Essentially, it would be something like this:
IF Status="pending" {Today's Date - 'Date Requested'}
This way for all pending requests we can see how many days it's been waiting for approval. I haven't used formulas in SharePoint before so if anyone can help me with the syntax that would be great.
Thanks
- Looking at something like
=IF([Status]="Pending, DATEDIF([Today()], [Date Requested],"d"), "")
Good reference: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
