List formula to calculate days since item creation if the item is "pending"?

Copper Contributor

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

1 Reply
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=offic...)