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 Request...
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)
=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)