Formula help to match contains

Christopher Neal
Christopher Neal ✭✭✭
edited 09/28/21 in Formulas and Functions


I have 2 sheets:

Sheet 1 contains [UserId] column

Sheet 2 contains [Assosiated User] and [Machine Name] columns

I need to Use [UserId] to look up if [Associated User] contains text to match [UserId] and return the value of [Machine Name] at row

Just cannot seem to figure it out. Any help is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!