Contact list column automation

edited 12/09/19 in Smartsheet Basics


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.


Jana Brits