Modify Dropdown cell value based on another cell

Options

I have a column for positions (Chair, Vice-Chair, NA) from a dropdown list, I have another column for Removed which is a checkbox. I need a formula that will change the position value to NA if the Removed box is checked.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!