If then formula with different sheets

Brian Oberstadt

Hello,

I am looking to create a formula that looks at the Tag Name/ID from these two different sheets. If they are the same, I want the Date Received in Full to show up in the Received by Van Ert column for that Tag Name.

For example: The Tag ID in line one on the first sheet is 410-AE-1391B. The Tag Name in line 581 on the second sheet is the same 410-AE-1391B. When we mark that device as received in full on the first sheet, I want that date to show up in the Received by Van Ert column.

Will it be possible to copy and paste that formula, or will I have to make a new formula for each line?

I am pretty new to Smartsheet. Any help would be appreciated.

Thanks!

Brian

Paul Newcome

Try this...

=INDEX({1st Sheet Date Column}, MATCH([Tag Name:]@row, {1st Sheet Tag ID Column}, 0))

Paul Newcome

Try this...

=INDEX({1st Sheet Date Column}, MATCH([Tag Name:]@row, {1st Sheet Tag ID Column}, 0))

Brian Oberstadt

Thank you!

Paul Newcome

Happy to help. 👍️