I have a doc with two tables:
- Team members: which has a “People type” column with the member’s name and three other text columns (role, location, area)
- Projects: has multiple columns, one of which is called Owner and it is a lookup of the people type column from the team members table
I’m trying to set automations based on fields in the projects column and I want to notify the Owner (so suppose the status of a project changes to launched, i want to send an email to the owner which is in the same row)
Does anyone know how to do this? I’ve tried using this formula in the to: field but doesnt seem to work =thisrow.owner