Auto fill form drop down list field in one particular scenario

Options

Hi. I currently have a column that can be either Capex or Opex depending on the chosen item from drop down list on a form. I have been asked to amend this so if another drop down list value is "X" then column Opex/Capex is to be autofilled as "Opex" else user the value entered on the form.... Any pointers for this please?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!