he3lp please

MATAYLOR

am trying to create a sheet that can autopopulate a column based on the information put into another...

but the problem is the column that needs to autopopulate is a contact column with is set to contact list so that when name in that column is entered it will notify that person. (Debbie@ brickability or john@brickability whoever is in that cell)

For instance...

·        column A (sold to ) will have text (site address) when site address goes in that Cell it triggers

·        column B needs to populate... (contacts name)...column b is a contact list,(which contains list of brickability contacts and emails) which would then have a automation to alert the person in that cell.

Does this make sense?

Andrée Starå

Hi @MATAYLOR

I hope you're well and safe!

Have you explored using a Workflow combined with the Assign people Action?

Would that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MATAYLOR

Andree

any chance you could give ma an example ?

thanks for helping

Genevieve P.

Hi @MATAYLOR

Here's more information about the Assign People workflow:

https://help.smartsheet.com/articles/2482227-assign-people-in-an-automated-workflow

Note that you would need to have specific conditions for when each person would be assigned, then set up Condition Paths to note who should be assigned.

Here's another Community post with screen capture examples: Workflow Alert Assignment

Cheers,

Genevieve

Andrée Starå

@MATAYLOR

Happy to help!

I saw that Genevieve had answered already!

Let me know if I can help with anything else!

Best,

Andrée

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MATAYLOR

thanks guys