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


1 Answer 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

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

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.