Nov 07 2018 05:10 AM
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
Nov 07 2018 07:21 AM