If then formula with different sheets



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.




Best Answer