Assigning One Person to Another Person

I have AR Specialists that are assigned to Property Managers. Each time I enter a new property and select the Property Manager from the drop down list, I want the AR Specialist column to automatically populate.

If the Property Manager in column 1/row 1 = XX or XX or XX, then the AR Specialist = XX

If the Property Manager in column 1/row 2 = XX or XX or XX, then the AR Specialist = XX

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!