1

Having a hard time finding this question already answered somewhere, so here it is.

I am trying to create a calculated column that returns the following result.

  • If "column 1" equals "OPEN", then enter "column 2" + 3

  • If "column 1" equals "PENDING", then return "Blank"

Column 1 is a dropdown list. Column 2 is a date.

I need the calculated column to return the date in column 2 adding three days, only if column 1 states "OPEN."

If column 1 states anything else, I need column 2 to be blank.

Any assistance is much appreciated

Improve this question
0

1 Answer 1

Reset to default
1

The calculated column "column 3" cannot change the value of "column 2".

You can display "column 3" and hide "column 2" in list view and DisForm.aspx, and display "column 2" in NewForm.aspx and EditForm.aspx (the calculated column will not display in NewForm.aspx and EditForm.aspx ).

Using the following formula in "column 3":

=IF([column 1]="OPEN", [column 2]+3, "")

enter image description here

Testing result of calculated formula:

enter image description here

Improve this answer
2
  • That is just what I was looking for. Works perfectly. Thanks so much
    – Ulcsmarine001
    Oct 2, 2018 at 1:58
  • @Ulcsmarine001 Please don't forget to mark the answer as accepted in case it helped you!!
    – Mohamed El-Qassas MVP ♦
    Oct 2, 2018 at 2:09

Your Answer

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

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