need help with a formula

so i have sheet 1 with rows


2.Tag Name


sheet 2 with rows


2.Cable name

3(would like the Row 1 from sheet 1 and change when I change it in sheet 1)

I would like a to make a formula to say IF sheet2 Cable name Matches Sheet 1 Tag name. then show Sheet 1 row 1(Priority) on Sheet 2 row 3.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!