Hi all, a bit new to this, hoping someone can help me.
I’m trying to create a formula to bring in a date from another table if the item exists.
For example
Table 1 - Product info
Item Name
Description
Date delivered (I want to bring in Batch date to this field if Item Name exist in Items Included below)
Table 2 - Delivery batches
Batch Name
Items Included ( this is linked to Table 1 with multi select)
Batch Date
How can I build a formula to bring in the Batch date into Date Delivered if the Item Name exist in the Items Included?