he3lp please

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!