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.