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, join the Smartsheet Guru Elite
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, join the Smartsheet Guru Elite
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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!