Issue: When using the Find formula, it doesn't work when trying to find the backslash (\) character

I can get the Find formula to work when looking for a letter but I need to locate the back slash (\) character but when I created the formula I get an #UNPARSEABLE error.

Example: The string to be searched looks like this "Noel\Mark\OfficeDesign" or "Abraham\Lee\kitchenDesign"

I need to pull the names, the first name is the manager and the second is the designer. I need to pull these names out into two separate columns for sorting and filtering.

Current syntax is =FIND("\", [Column14]1)

If I replace the \ with a letter it works but it doesn't like the \ character even though it's in quotes.

How do I get this to work?

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Glenn Neargarder

Strange!

Is this a recurring process, or could we replace the \ with something else before it ends up in Smartsheet?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Glenn Neargarder

We are a group of engineers. Currently there are 3 senior engineers and each of them have ~ 5 lead engineers. We have about 200 projects. We create a folder for each senior and sub folders for each lead. All the projects files are stored under the leads name.

We have an Excel macro that goes to the hard drive and pulls all the files and provides the path. We use this path as a link and we use it know the senior and lead engineers.

the path looks like this \\server\pce_cqf\TEMPUS\Projects\Julian\Joseph G\SATM Design Project.mpp|

I need to pull the first name and place it in the Senior Engineer column and the second name for the Lead Engineer column. This will allow us to sort and filter the list of 200 projects by Senior or lead.

Does that help?

Andrée Starå

@Glenn Neargarder

I hope you're well and safe!

Excuse the late response.

Crazy times and I missed coming back to you.

Have you solved it, or do you still need help?

Happy New Year & Stay safe!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.