Automatic Formula in Add Row Workflow
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.
Best Answer
-
@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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@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, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Worked like a charm! Thank you!
-
@JoannaAU Great! Thanks for letting me know!
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!