Easy question. I have a first name field (B1) and last name field (C1). I’m trying to merge the results in a Full Name field with formula B1 + “ “ = C1. However, nothing populates in the field. Need help!!
Hello @scott.allen - Are you trying to make the merge of those fields ONCE-OFF ? For only one time?
Or establish a formula that will do this all the time?
IF First name field (B1) is stored in Column B
&
Last name field (C1) is stored in column C
and you need this to be always active (the formula I mean)
You need a Column to store the Result of the formula
B1 + “ “ + C1 = D1 (for example). Am I wrong, Am I missing something?
Best Regards.
Ilias
Trying to establish a formula that will do it all the time. I typed the wrong starting formula. The two fields I’m trying to merge B1 and C1 (First Name and Last Name respectively) are to be displayed in field J1 that is labeled Full Name. It will take B1 + " " + C1 as the formula but it does not display any results, the field remains blank. I hope that better explains.
1 Like
Hi @scott.allen - please check the text I post below this line:
A string formula : if the value in B1 is “Allen”, and C1 is “Scott”, then “B1+C1” = “AllenScott”.
If you want to add a space between two strings, you can use “B1+’ '+C1”, resulting in “Allen Scott”.
The issue seems to be that the SPACE = ’ ’ (must be single quotes)
AND the whole Formula must be = B1+’ '+C1
Please check this case and let me know here or via Email.
Ilias
I entered the formula you prescribed. It accepted the formula but did not display results. Is there a way for you to view my sheet and see if there is something I may be missing?
1 Like
@scott.allen - as far as I can recall, we have 2 options available.
A) You give me details on the fields, what data type each field data is
so that I can check if there is an issue with data types
B) You give me temporary access to the table, but this is not usually preferred.
I am trying to think of possible cases of a formula malfunctioning. I will make a test in a template of my own.
Ilias
@scott.allen I have tested in a template of mine, and It seems that I have the same problem.
I think that the issue has to do with “Recalculation” of formulas or smth like that. I believe that the syntax of the formula is correct. I will look towards that way (“Recalculation”).
I will let you know, asap.
Ilias
ADD.RAW eg. B1.RAW+" "+C1.RAW (for text field)
Hello @Rbhade and @scott.allen - Neither this is working for my template test also.
I do not know why. I could not ask the Team in Ragic, but I will today.
Ilias
Hi there - if you’d like to discuss the issue with us here at Ragic Support, feel free to send us an email at support@ragic.com. Please include the relevant details such as the URL to a sample sheet and the expected behavior to build. We will take it from there. Thank you.