Update Cell if A Different Cell Changes

Frank S.
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", "")

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

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

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Frank S.
    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?

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Mark Cronk
    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Frank S.
    Frank S. ✭✭✭✭✭✭

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

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

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

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!