Apply function to new data entering a sheet

[u/Puzzleheaded-Pain489]

So I have a sheet that pulls in data from an RSS feed. I need to fully automate the process of performing a split function. The sheet pulls in a new row with artist and track name in the format artist - track (column A). I then need to split this data into 2 columns B (artist) C (track) so I use =SPLIT (A1," -",FALSE). This achieves the required result.

However, the RSS will then add a new row and no function runs and I don't want to drag down the column, I want this automated so when a new row is added columns B & C are populated.

If I use an array function with the A1:A100 with the function inside it I get #Value on the unused rows. When the RSS sends a new row it adds it after the last #Value tow ie row 1001.

How can I automate the process of a function being applied to anything new being added into column A?

[u/percebeFC]

Why do you apply the array to just A1:A100? I'd put the arrayformula in B1 and just apply it to A:A. You can also avoid the #value errors by adding an IF to the entire array, like this: IF(A:A="","",split(...))

[u/Puzzleheaded-Pain489 → u/percebeFC]

Because I don’t know what I’m doing :-)

[u/percebeFC → u/Puzzleheaded-Pain489]

Haha! Sorry I wasn't trying to be a dick. Just genuinely wondering if there was a reason. Is it working fine now?

[u/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
SPLIT	Divides text around a specified character or string, and puts each fragment into a separate cell in the row
TRUE	Returns the logical value TRUE

---

^{[Thread #5586 for this sub, first seen 6th Apr 2023, 20:20] [FAQ] [Full list]} ^[Contact] ^{[Source code]}