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