9 февр. 2019 г. · Sheets is giving me the error "Function TEXTJOIN parameter 2 expects boolean values. But 'Sally' is a text and cannot be coerced to a boolean."

1 сент. 2022 г. · I'm trying to get textjoin to ignore blanks here, but even with the “true” argument it's still returning the delineator for empty cells. What am I doing wrong ...

19 янв. 2024 г. · I'm trying to create different mailing lists depending on specific criteria. If someone has a score of 50 or lower then their email is added to the high ...

23 февр. 2021 г. · In Google Sheets, it just straight up doesn't work. I get an #ERROR. Any ideas on how I can get this going? I really wanna work in Sheets as ...

21 сент. 2021 г. · I got to textjoin and filter to do what I need it to do, but when I try to layer in sorting, the formula returns an error. I can sort ...

11 июн. 2024 г. · I am currently working on a form for work that has a cell (B8) we need the team to fill out that's current formula is =TEXTJOIN(Char(10),1 ...

24 апр. 2022 г. · Background: I am helping a friend with a blind auction event and I need a list of items that someone won to display in a single cell.

18 июн. 2020 г. · The error reads "Text result of TEXTJOIN is longer than the limit of 50000 characters." A literal array is where you create the array using ...

27 июл. 2024 г. · Break the data into smaller chunks that fall within the character limit, join those with the formula, then copy and join the outputs manually.

2 авг. 2021 г. · If I make the body text too long, I get a #VALUE! error. My understanding is that this has to do with Excel's character limit. Is there any to get around this?