Using a datafile to 'autofil' cells

cpage

Was wondering if there was a way to upload a external data file (csv) and get it populate cells.

IE - Could I load a list of 'Stakeholders' (make it a dropdown list) - and based on that selection from that dropdown list, it automatically fills in another cell, with lets say that 'Stakeholders Manager'

So basically 1 cell is automatically populated based on the 'Selection' of a dropdown value from another cell.

Anyone have any thoughts on how to accomplish this?

J. Craig Williams

A few issues you will run into:

There is no way to have a formula update a Contact List, which I assume [Stakeholders Manager] column to be.

There is no way to have a CSV file imported into a pre-existing Sheet using the GUI.

I have developed solutions that import into Smartsheet, manual copy, and linking using X-Sheet References, but they can be difficult to setup or maintain and I do not use them lightly.

I think everything you describe can be done using the API. I have a solution that I run one or more times a day to get a CSV file into the system. If I could automate the CSV file generation, it would be completely seamless. 

Craig