Help expediting Data Entry

Sergio V.
Sergio V.
edited 12/09/19 in Smartsheet Basics


Looking to get some help speeding up our data entry process. We have a note that looks like this: Name: John Doe Phone: 555-555-5555 Email: about 15 more fields. These fields need to be taken from the note and manually input in our Smartsheet. 

I would like to know if it's possible to paste a block of text and have Smartsheet categorize each section into the corresponding cell. We had this data entry setup at a previous office that ran with Openoffice, however, I don't know which formulas were being used. We're currently using forms to submit the content, however, the original source is text-based and cannot be changed, meaning the data entry process needs to take place.

If anyone can provide assistance it'll be greatly appreciated.