he3lp please


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!