Autofill Assigned To with contents from first 2 cells

Options

Hi all,


I want to create a template which has a couple of rows at the top which then control what is set in the cells below - when the new sheet is created from the template Row 1 will be assigned to (example) Albert, Row 2 should be assigned to (example) Bertie.


What i would then like to happen is have all the rows below which are assigned to Holder A be reassigned to Albert and those who are assigned to Holder B should be reassigned to Bertie


Any suggestions on how this could work?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!