4

Im no expert but I seem to be struggling with this.

I have a calculated column field called [Review Days] for which I hope to enter an amount of days that a document will need reviewing. 1 year will equal 365 days, 2 years, 720 days etc.

I can get this to work no problem.. the problems is, if [Review Days] is blank then I want to default this field value, [Next Review Date] equals [modified] + 1825 days or 5 years.

I kinda see something like this:

=IF(  ISBLANK([Review Days])  ,  ""  ,  Modified+1825  ,  [Modified]+[Review Days]  )

Any help will be much appreciated.

Thanks Mike

2
  • 1
    An IF function has True/False results, you have 3 results Commented Apr 11, 2017 at 11:37
  • =IF(Review days="";[Modified]+1825,[Modified]+[Review Days])
    – user67129
    Commented Jun 7, 2017 at 13:25

2 Answers 2

5

Try this:

=IF(ISBLANK([Review Days]),Modified+1825,Modified+[Review Days])

Ensure that the calculated column is of Date type.

enter image description here

More information on ISBLANK:

-1

Try this

=IF(Review days="";[Modified]+1825,[Modified]+[Review Days])

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.