need help with a formula

Alex Klingbeil

so i have sheet 1 with rows

1.Priority

2.Tag Name

3.Blank

sheet 2 with rows

1.Blank

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.

Maaik Meijerink

Hello @Alex Klingbeil,

Your explanation seems a bit confusing, but nevertheless:

If you make a formula in Sheet 2 Row 3 which looks like this and of course you have to make the references yourself, this would do the trick:

=IF([Primary Column]2 = {Sheet 1 Tag Name}; {Sheet 1 Priority})

For making references, have a look at https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Maaik Meijerink

Hello @Alex Klingbeil,

Your explanation seems a bit confusing, but nevertheless:

If you make a formula in Sheet 2 Row 3 which looks like this and of course you have to make the references yourself, this would do the trick:

=IF([Primary Column]2 = {Sheet 1 Tag Name}; {Sheet 1 Priority})

For making references, have a look at https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets