Make my primary column a contact list

Fritz Schiltz
edited 05/10/21 in Smartsheet Basics


I would like to make my primary column a contact list. I know that this is not possible so I tried to copy the whole column using a simple = formula, but as Smartsheet only has 50 cells, this is only a temporary solution.

My goal is to alert someone (send to contacts in a cell), in order to do that I need a cell with e-mail address filled in that is formatted as a contact list. How can I do this?



Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    @Fritz Schiltz Changing a primary column is not directly possible. However, you can always copy and paste the text from the other column into your primary column, and change the header name. The primary column does have to remain a text/number column.

    I'm not sure what you mean by Smartsheet only has 50 cells, but you can right click on a formula (even in the Primary Column) and click "convert to column formula." This will make all of the cells in that column - whether currently in the sheet or added in the future - populate the formula.