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 ✭✭✭✭✭
    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"))



    Reach out for any help on licenses, configuration, or training


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!