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)
· 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
Check out the Formula Handbook template!