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: [email protected]-and 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.



Hi Sergio,

It's probably possible!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic week!


Andrée Starå

Workflow Consultant @ Get Done Consulting

In reply to by Andrée Starå

Thanks for replying Andree! Yes, the text is provided in the same format, it looks something like this:

"Assigned to: John Doe Status: Pending Date: 1/1/2019 Customer: Jane Doe Phone: 555-555-5555 Email[email protected] Priority: normal Comments: The quick red fox jumped over the lazy brown dog."

The sheet in question has a column* for each value in bolds. There's 24 values in total. I would share a sheet with you however I'm not sure what our internal policy on sharing outside the company is at the moment.

I'm gonna check the MID and FIND functions as suggested(thanks Paul) but would appreciate any assistance.

In reply to by Sergio V.

Is it rows or columns for the values?


1. Assigned to              Status               Date

2. Assigned to              Status               Date



1. Assigned to

2. Status

3. Date

4. Assigned to

5. Status

6. Date