Google Sheet Update Record

Queries and Resources
1

I'm trying to filter by three criteria & update a record in a google sheet but the headers start on the second row. Is there anyway around this?

  • message:"column "Record ID" not found. expected column name to be one of "untitled", "2023-01-10 08:41", "untitled", "untitled", "2", " untitled"."
2

Hi @AndrewOwen! Are you able to use A1 notation instead (linked under 'Filter by')? Using A1 notation, you can indicate that the update query should not look at the first row

1850×392 27.9 KB

Example of using A1 notation to start on the second row of a sheet:

1784×202 24.2 KB