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

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 – Ulcsmarine001 Oct 2 '18 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 '18 at 2:09

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.