Formula help to match contains

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

Hello!

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!