Feb 26, 2021 01:22 PM
Seems simple but I am struggle.
i have the adress of my website on one colum lile
Column D : www.site.com
I have some slug in another on like
Column E : - “page1/” on row 1, “tomato/” on row 2
I want to display in one colum the
sum of the two, like D & E.
www.site.com/page1/
www.site.com/tomato/
I know it’s basic, but I haven’t found so far…
I was thinking I need roll up, but it say “You need a link field to create a rollup. Create the link field before configuring this rollup field.”.
And I don’t get it ( maybe because I am french).
Feb 26, 2021 02:38 PM
Seems like you need a Formula field.
Use a formula like this:
{Column D} & '/' & {Column E}
or just
{Column D} & {Column E}
if the forward slash is already accounted for in your slug field.
Feb 27, 2021 02:06 PM
Thx you so much for your prompt reply.
I have just tried, and I have an error.
I then try to do a realy basic formula, and I still have the same message.
I put in copy the screen and the formula.
Can you help ?
Feb 27, 2021 02:10 PM
Well apparently none of your columns are actually named ‘Column D’, so there’s your problem lol
When inputting content from another cell, put the name of the column in brackets (i.e. {Notes}
). When just inputting text, put it in quotes (i.e. "this is some text"
)
Feb 27, 2021 02:12 PM
Wooh impressive how reactive, you are.
No it’s not the problem, see below… i select the name of the column in the drop down menu to avoir mistake while typing.
Feb 27, 2021 03:26 PM
As said before, if its part of the name of a column then it goes in brackets. If its text you want to appear in the output put it in quotes.
Either delete the word column
or put it in quotes.