Automatic Formula in Add Row Workflow



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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!