Formulas

swightman

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.

AravindGP

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

AravindGP

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

swightman

Thank you!!! That worked perfectly!