Smartsheet assistance.
@Genevieve P. I hope you are well?
I haven't message in the forum for a while as my Smartsheet has expired and it has taken me a while to get a license.
I was wondering if you can assist with a issue I am having with a project I am working on.
I am creating a timesheet form and I require some sort of automation or something similar.
In my sheet I require if one cell is change it populate another cell with something that is already logged elsewhere.
for example in my sheet if I change the project manager name to : John smith from my dropdown list(contact list), in another column or sheet to John Smith = UK.
I hope I am making sense I have attached my work so far and make a comment to try and make it clearer.
In advance I hope you don't mind me messaging you directly as you have helped me previously and it worked.
Thank you in advance.
Answers
-
There are a few ways you can do this.
If you have fairly small list of countries and they each correspond with a set list of people, then I would suggest using a Change Cell Workflow.
See: Change the Value of a Cell in an Automated Workflow
You can use Condition Blocks to identify the different people, then the associated Country.
See: Condition Blocks: Filter What Your Automated Workflows Send
If you have too many countries, then yes, you could have a second sheet where One Column has all the Countries listed and then a multi-select column lists all the people associated with each country.
Then you would use an INDEX(COLLECT formula to bring back the Country based on the Assigned To value:
=INDEX(COLLECT({Country Column}, {Multi Contact Column}, HAS(@cell, [Assigned To]@row)), 1)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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