Number of Days Outstanding

Question

How to calculate number of outstanding days in SharePoint? I've been using the formula below but it is not stable

=IF([Document Status]="",TODAY()-[Initiated On]+1,[Date Reviewed]-[Initiated On])

what is the output you are receiving? Information you have provided is not sufficient to resolve the issue. What is it not stable, if block or else block — Gaurravs, Jan 17 '16 at 07:35
When a Document Status is empty you want to display the number of days it is outstanding As explained in an answer below, you can not use the TODAY() function like this, because it is only evaluated when the Item is updated (thusacts the same as using [Modified] — Danny '365CSI' Engelman, Jan 18 '16 at 09:27
I need a column that will start counting the number of day base on "Initiated On" value and the counting should stop once column "Date Reviewed" is provided. I've tried the formula provided earlier and it work but somehow other values are incorrect. — Jong Mendoza, Jan 18 '16 at 16:23

score 0 · Answer 1 · edited Apr 13 '17 at 12:41

0

Formulas will only update when the List Item is modified/updated.

That means Today() is the same as [Modified] (last date the item was modified)

For long explanation and possible workarounds read:

edited Apr 13 '17 at 12:41

Community

answered Jan 17 '16 at 09:49

score 0 · Answer 2 · answered Jan 17 '16 at 13:59

You can display outstanding days using CSR (Client Side Rendering).

The conventional way is to write JS code and inject it in the library view. More details here: https://code.msdn.microsoft.com/office/Client-side-rendering-JS-2ed3538a

2 Answers2