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.


Tags:

Answers