Delegation warning. The filter part of this formula may not work correctly for large data sets.
This is the warning message. This come for all the warning messages.
Will your list ever grow to more than 2,000 rows? If yes, this formula will not work past row number 2,000. TRIM cannot be delegated.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Class of 2020- Season 2
Featuring samples like Return to the Workplace and Emergency Response Applications
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Features releasing from October 2020 through March 2021