How to create a workflow/formula to reference a cell when the conditions are met in the same sheet.

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Jessica Nguyen

    Hope you are fine, as i understand from your attachment please try the following workflow


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Hi Bassam - Thank you for looking into this. I must miss something from your suggestion because it seemed not working. Just to clarify my use case, I don't want to alert anyone. However, I need to copy/reference the Owner column with the value in Jira Assignee column when these 2 conditions are met. Many thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!