Importing from Excel to Smartsheet (Grid) using names for contacts
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would like them to come in (during the import) as SS contacts (name, icon, email shown and can be used with automation, etc). I searched this and tried a number of things and determined (not sure) that I don't think that is possible. I can do this if I have the email but it doesn't really give me the SS contact that I want. SO, I tried using FirstName<sp>Lastname , <[email protected]> as the value, that did not work, and I tried to build that after the import and reference the cell to a cell in a col. that was contact list. I also tried to use the Name pulled into the import and reference the cell from another SS grid into a col. for contact list, that did not work. I then tried to build a lookup table with one column as Name (first last) then a col next to it with the SS contact for that name. Then in a SS grid, I used the Vlookup with no luck and then tried Index/match which did something interesting. It seemed to work but was inconsistent. After some research, it appears to be working for only those users in SS that are admins. Very difficult to figure out but I need some way to work with a name in a xl ss, and get it to a SS grid where the SS contact shows. I don't think I will have email available unless I use a lookup but using email does not give me the same SS contact that I would get if I simply started typing the name and chose from the lookup. Any help would be apricated.
Happy to help if I can.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer)
Help Article Resources
Check out the Formula Handbook template!