Modify Dropdown cell value based on another cell


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!