Automation Issues

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

Hello @rebs!


should do the trick