Is there a way to use a formula to tell my contact cell to populate based on another field?


So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the "team" field, then add this matching contact to the "Assigned to" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation

Best Answer


  • Melissa Logan

    A source sheet is exactly what I needed, thanks!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!