Is there a way to pull Start and Finish data from a cell that has both? I'm importing a spreadsheet schedule with cells that have both dates expressing a date range, eg. "2/1 - 2/7"
You'll need to build a parser.
Depending on the consistency of the data, I might do this in the other spreadsheet (Excel and OpenOffice have macros, for example) or parse it between export and import.
It might be a simple a splitting the data at the hyphen, in Smartshet that would likely start with the FIND() function.
Also depends on volume.
For Smartsheet's import, there is not a way to redirect one column to two or more during the import process
Craig
