I really need to import or copy and paste contacts - but how?

CycleBagEd ✭✭
edited 09/30/22 in Smartsheet Basics


I need to import, each week, a series of assigned rows from another system.

As far as i can tell, the only way to do this is to copy text into the contacts cell and, laboriously, click on each one to change it to a contact. This will be about 1200 clicks, although I can reduce that by some dragging with rows in the right order.

Now, this doesn't seem acceptable. I can't use a VLOOKUP because they don't work in contact columns. I can't manually copy and paste an email address, because that doesn't work.

I can use find and replace as this seems to trigger the contact list to lookup the Smartsheet user and assign it as a "proper" contact - but this will take longer than the dragging option.

Can smartsheet please change the system so a pasted email address which matches the system address gets converted into a contact?