Set Value Based on Column Match from Separate Tables

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.

Hey there!

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

4 Likes

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.