IF Formula with Multiple Choice


I want to build an IF formula into columns when the multiple boxes has selected the right department.

IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done.

Would appreciate your help greatly!! Thank you very much.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!