Formulas

I am trying to write a formula that would enter a text based on the text in another column with both columns being a dropdown.

For example if in column D the text is Pass I would like the formula to choose Complete in column A, if in column D the text is Under Review column A should state In Progress.

Best Answer

  • AravindGP
    AravindGP Community Champion
    Answer ✓

    Hi @swightman


    You will be adding the formula in Column A and it would be something like this. =IF([Column D]@row="Pass", "Complete", IF([Column D]@row="Under Review", "In Progress"))

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!