I have a Google Sheets template that locations are making a copy of. A small percentage make the copy successfully and are able to use then randomly the formula's return #REF. All formulas are internal to doc with no outside references. I verify the formula =ARRAYFORMULA(TEXTJOIN(" ",FALSE,IF('Summary Page'!$B$11:$B=F17,'Summary Page'!$K$11:$K,""))) has items in column B and column k and yet it returns #REF. Once again, the formulas work the first couple days then go kaput after a few days.

  • Hi and welcome to WebApps. Would you please provide sample data so that we can recreate the problem that you are having. Would you please also describe the formula outcome when it is successful. Lastly, please describe how the values in Column B&L and Cell F17 are determined.
    – Tedinoz
    Jan 12 at 3:37


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.