Set Value Based on Column Match from Separate Tables

[Sara_Jean_Kwapien]

Hello!

Racking my brain here on this one.

I have two tables, one for announcements and one for presentations. I’d like to automate the cancelation column in the announcements table to match the cancelation status in the presentations table by finding the matching date and checking the cancelation status. Halp!

Sorry I can’t link the doc to make it easier! Hopefully the screenshot helps.

[Scott_Collier-Weir]

Hey there!

No need to do an if() statement - you can simply filter() then reference that columns value

[Sara_Jean_Kwapien]

Thank you, Scott! Exactly what I was looking for!