Hiya,
this is most definitely a noob question, but I’m trying to set up a formula that references a lookup column in one table and combines it with a number column in the current table. What results is a weird
string that makes no sense: grid-kqSA4xSes9/i-PREgxS65nM-867
I don’t know how to share a screen shot of the result.
Hey @Christina_Crowder! I think it’d be helpful to see your doc so we can see what your setup looks like. Could you embed it here? If you’d rather share it directly with support, feel free to reach out through the chat icon in the lower right-hand corner of your screen, or email support@coda.io.
Hi thanks so much @Jasmine_B, but I don’t think embedding the whole document will help – also it is massive, and not describing a normal business-like process. I see now how to put in a screen shot tho. I think it may be that the formula is trying to refer to a formula and I got to a workaround by bringing in the individual columns that make up the formula in the sheet I’m referring to. That works ok, but it seems kind of annoying to have to do it every time. It would also be helpful if the formula bar would not keep forcing columns that are labeled as text in the “grid” layout to be made into numbers in the formula builder – if I wanted it to be a number I would have made the column that way!!!
Hi @Christina_Crowder 
!
From your screenshot (thanks for sharing 
), you’re actually mixing some data types (a row reference, some text and a number) and concatenating things using + is generally not a good idea (+ is more often than not interpreted as an addition and using it to concatenate values can lead to unexpected results) 
…
What you could do though is using Concatenate() or Format() to combine those values
E.g.:
Concatenate(
thisRow.[Admin Heft].[Name],
"-",
thisRow.[K#]
)
Format(
"{1}-{2}",
thisRow.[Admin Heft].[Name],
thisRow.[K#]
)
What the thisRow.[Admin Heft].[Name] does in both sample formulas, is getting the value actually stored behind the row reference thisRow.[Admin Heft] (I.e: the actual value stored in the field you set as Display column in the table where your row reference is sitting)
I hope this helps
Great, thanks so much. I’ve never used “concatenate” in the past in Excel or other legacy programs so figuring this stuff out has been tricky. Many thanks. cc
I’m very glad to know it helped @Christina_Crowder 
!
There’s another possibility I forgot to mention ( ) : using List() (or ListCombine()) and Join() too
E.g.:
List(
thisRow.[Admin Heft].[Name],
thisRow.[K#]
).Join("-")
oh… that’s super cool tool. I’ll likely use that as well in different places.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
