Update Cell if A Different Cell Changes

Frank S.

Here is my problem:

Column A has dropdown values: Open, closed, pending, approved

Column D has dropdown values: Approved, Deferred, Escalate

I created a helper column and what I'm trying to do:

if column D change to approved, column A will also go to approved

If column D changes to escalate. column A updates to approved

if column D change to differed, column a will update to closed

I have other combinations but want to start there.

My starting point:

=IF([Column D]@row = "Escalate", [Column A]@row = "Approved", "")

Mark Cronk

Excellent. Glad you found a solution. Thank you for bringing a great challenge to the Community.

Mark

Mark Cronk

Try this formula in Column A:

=IF(OR([column D]@row= "approved",[column D]@row= "escalate"), "approved", IF([column d]@row=a"differed", "closed", "open"))

I don't see a need for a helper.

Work?

Mark

Frank S.

@Mark Cronk

The reason I thought a helper column was needed is that column A is a dropdown column that already has a value. I can not add a formula to a drop down column.

Am I doing something wrong?

Mark Cronk

Good evening, If column A is a formula then it doesn't need to be a drop down. Helper columns are used as an intermediate step when you can't process all the logic in a single formula. I may not be understanding your need. Is it working for you?

Mark

Frank S.

This problem is resolved with the new automation functionality that allows a cell to be updated.

Mark Cronk

Excellent. Glad you found a solution. Thank you for bringing a great challenge to the Community.

Mark