Hello, I have a simple issue with app sheet formula but I can't seem to understanding it rationally. I have not much knowledge in this domain. Anyway I have First name and Last name in my sheet. Appsheelt lets me choose only 1 primary header colum for the display. I would like to display the full name. I am trying to add a virtual column that compute first name + last name (referenced by client id) = full name.
Also, would it be better to simply have full name and not segregate first name and last name in sheet afterall? idk...
[Firstname] would return the first name ( or [ClientID].[Firstname])
[Lastname] would return last name ( or [ClientID].[Lastname])
I cant seem to find how to return both together.. like you can not do + cause it gives error and it makes sense too I believe but how to get the result I expect?
Solved! Go to Solution.
Found the solution. Asked chatgpt and he said to use [FirstName] & " " & [LastName]
What I did is [ClientID].[FirstName] & " " & [ClientID].[LastName] as an app formula with a virtual column.
I am now able to display full name. Thank you. Thanks chatgpt lool.
Found the solution. Asked chatgpt and he said to use [FirstName] & " " & [LastName]
What I did is [ClientID].[FirstName] & " " & [ClientID].[LastName] as an app formula with a virtual column.
I am now able to display full name. Thank you. Thanks chatgpt lool.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |