Using an automation I’m trying to update a row meeting specific criteria in separate tables.
Both of these tables refer to a third table via lookup columns for “Contacts”. I want to filter based off of status and that the clients match from each table.
Here’s what I have
ModifyRows(Filter(Inquiries, Status = “Invoiced / Awaiting Payment”), Filter(Inquiries,Client=thisRow.client),Inquiries.[Mark Complete], True())
But the formula wont let me make sure that the client column in one table and the client in another match. Please help if you can.