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 firstname.lastname@example.org.
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!!!
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 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)