If then formula with different sheets
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
Best Answer
-
Try this...
=INDEX({1st Sheet Date Column}, MATCH([Tag Name:]@row, {1st Sheet Tag ID Column}, 0))
Answers
-
Try this...
=INDEX({1st Sheet Date Column}, MATCH([Tag Name:]@row, {1st Sheet Tag ID Column}, 0))
-
Thank you!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives