If Function


I need a formula to assign people to a cell based on a person assigned in another cell.

For instance:

If the cell is assigned to Russ, Tyler or Kirk it needs to say Lauren.

If the cell is assigned to Mason, Bryan or Will then it needs to say Cynthia.

Column name is "Assigned To" and the first name goes in line 2



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!