Smartsheet assistance.

Majid Kayani

@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.

Timesheet App.xlsx

Genevieve P.

Hi @Majid Kayani

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