"\" Character in String

Forum

Id like to create a formula that mirrors 'Concatenate' from Excel, so Id like 3 items concatenated; 2 sources from 2 columns on my sheet and the third is a manually written in text string with the formula itself:

Column A

Tet String abc\123 [as an example]

Column B

I can use "+" or JOIN it seems, but the fact my text string part of the formula has a "\" seems to throw the formula creation and doesnt allow it? Or if it does, the "\" is auto removed.

Any ideas why? Work around?

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Andi,

It should work, and it did when I tried, but I'm uncertain that I've replicated your exact scenario.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andi Hawes

The full query:

id like:

pw:\\PROJECTWISEV8I:PWISEV8i\Documents\Central\Midland Mainline Route Modernisation\Network Rail\Engineering\Technical\CAD\Models\ [which is my text string]

joined with

SSM2 [where SSM is my column name and 2 is the row number]

joined with

?Version= [text string]

joined with

=Version2 [where Version is my column name and 2 is the row number]

This then auto creates a link string for ProjectWise application as the hyperlinking to ProjectWise doesnt work in SmartSheet

Mike Wilday

=Join("pw:\\PROJECTWISEV8I:PWISEV8i\Documents\Central\Midland Mainline Route Modernisation\Network Rail\Engineering\Technical\CAD\Models\",SSM2, "=","Version2")

Would this work for you?

Mike Wilday

You could also replace the 2 with @row to make the formula row independent. *Assuming this formula will go on the same row as the other columns you are referencing.

Andi Hawes

Slightly wrong from my request, but even your string itself doesnt work

Andi Hawes

Had to resort to putting the ProjectWise string into a column, and then reference the column, rather than have the ProjectWise string in the formula itself

Mike Wilday

Ah, I see. Join is looking for a range... not a number of items. My bad. Glad you got it worked out.

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…