Referencing columns in row names

1

Hi there,

I am trying to do a basic naming convention, taking the name of a few columns to create a name for each line.

Here is the formula,

thisRow.[#] +“_”+ thisRow.[Owner OS _ Program Milestones]

I have attached a copy of the output. Any ideas on how to fix this_

Thanks,

Andy

image
image624×124 7.6 KB

2

:waving_hand:t2: @Andy_Farquharson2

welcome to the community ! :hugs:

have you tried to use Concatenate() or Format() formulas

hope this helps!

cheers!
Mel

1 Like
3

Hi Andy,

Welcome to the Community!

Do you want the answer to be “0 Welcome” ? “+” is a mathematical operator, to join the contents of columns to together, you need to use Concatenate(), Something like Concatenate(#, “ “, Owner OS_Program Milestone)

Also bear in mind that it is generally not a good idea to use special characters at the beginning of a column name.

Regards

Piet

4

THanks for the quick replies. This solves my problem, thank you!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.