Dear community, as I understand it, the label column cannot be labeled using a formula. Based on my understanding of the data structure, this leads to a dilemma for me and I'd be curious if anyone might find a workaround or a flaw in my underlaying thinking. Here is the background:
I have roughly speaking a table with assets, a table with clients and a table with projects, in which the assets are being brought together (sold) with the clients in a series of steps.
Thus, the label column of my assets table consists of the asset names, the label column of my clients table consists of client names.
When I create a new project, I reference the client and the asset in question, which would naturally result in a project name consisting of a combination of the two. I would therefore love the label column of my project to be =[Asset Name]&" "&[Client Name] instead of having to type it in with the additional risk of typos.
Same for my client names: I have a column with first name(s) and last name(s). Why can't my label column be =[First Name]&" "&[Last Name]? Am I missing something?
I know, it's not the end of the world having to label the projects manually and typing the combined client names in addition to separating them into 1St and last but isn't the point of what we're doing to automate the boring stuff? I'm no coder so forgive me if I'm missing something.
If anyone has a solution for me, I'd be very grateful!
Thanks in advance for any help!
LinkedIn
Twitter
