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 ...
thank you Mo. that worked beautifully. is there a way to do this using a formula in case I want to add another condition like an if batch type = “food” to bring in the date?
