Contact list column automation

Jana@al-a

Hey

I have two columns "Admin support" and "Project Manager" in one of my template sheets that I am busy creating. It is a TEMPLATE sheet  that will be used in many projects and I need it to be easy for anyone on our large team to use the sheet. These two columns will have the same admin support person and project manager for the entire project and therefor will be hidden to save space.

The two columns are used in many automated workflows (alerts/approval requests etc) and therefore I need the columns to preset the workflows in the template. I was wondering if it is possible for those two columns to be filled automatically as soon as 'n new row is added in a sheet. The columns have to be contact list columns in order for the workflows to work.

Regards,

Jana Brits

baddams

I've only been able to make that work when I'm using forms to add data. Formulas will auto-populate but values won't. And unfortunately, you can't put formulas in a contact column.

Jana@al-a

Yes, that is my problem with the formula and even if I populate it before had the automated date column automatically safe the date the line was created as soon as I put a contact person in that line.

Paul Newcome

How are new rows being added?