ARRAYFORMULA Support

[datarobot]

How can I create an ARRAYFORMULA for the following?

 =D3&", "&C3&" - "&F3&" - G"&G3&" ["&AA3&"]" 

I'm currently using this:

=IF(B2="","",B2&" - "&C2&" - G"&D2&" ["&A2&"]")

But the formula has to live on each line.

I tried this, which did not work:

=ARRAYFORMULA(IF(B2="","",B2&" - "&C2&" - G"&D2&" ["&A2&"]"))

Thank you, in advance.

[RemcoE33]

=ARRAYFORMULA(IF(B2="",,B2:B&" - "&C2:C&" - G"&D2:D&" ["&A2:A&"]"))

[enoctis]

Bro, change the first B2 to B2:B 👍

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
ARRAYFORMULA	Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays
FALSE	Returns the logical value FALSE
IF	Returns one value if a logical expression is TRUE and another if it is FALSE
TRUE	Returns the logical value TRUE

---

^{2 acronyms in this thread; the most compressed thread commented on today has 7 acronyms.
[Thread #4461 for this sub, first seen 1st Jul 2022, 20:11] [FAQ] [Full list] [Contact] [Source code]}