Formula for pulling Start and Finish from cell

Chuck Kahn

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"

J. Craig Williams

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