Automatic Formula in Add Row Workflow

JoannaAU

Hello.

I have Sheet A which copies the rows to Sheet B once rows in Sheets A have been approved. Sheet A includes a country column and Sheet B includes both a country and region. I would like the region column to automatically generate the region value based on the country value. I have a separate region and country sheet that could be used with INDEX MATCH or VLOOKUP. How can I create the logic that when a row is added to Sheet B from Sheet A, the region value is automatically generated? Thank you in advance.

Darren Mullen

@JoannaAU if you create a column formula for the region column in the destination sheet with the lookup functions, it will automatically pull on the matching value when a new row is added.

Darren Mullen

@JoannaAU if you create a column formula for the region column in the destination sheet with the lookup functions, it will automatically pull on the matching value when a new row is added.

JoannaAU

Worked like a charm! Thank you!

Darren Mullen

@JoannaAU Great! Thanks for letting me know!