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

| improve this question | |
  • 1
    An IF function has True/False results, you have 3 results – Danny '365CSI' Engelman Apr 11 '17 at 11:37
  • =IF(Review days="";[Modified]+1825,[Modified]+[Review Days]) – user67129 Jun 7 '17 at 13:25
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:

| improve this answer | |
-1

Try this

=IF(Review days="";[Modified]+1825,[Modified]+[Review Days])
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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