79714015

Date: 2025-07-24 22:27:14
Score: 1.5
Natty:
Report link

I know this issue is an old one. I had the same issue just now and I was wondering if there was a more efficient solution to this. Upon reading the thread, I found out isformula does not work with arrayformula. Anyway, this is what I came up with. Hope this helps especially for those who will come across this in the future.

=arrayformula(if(B2:B<>"",isformula(B2:B),iferror(0/0)))

Reasons:
  • Blacklisted phrase (2): was wondering
  • Whitelisted phrase (-1): Hope this helps
  • Whitelisted phrase (-1): I had the same
  • No code block (0.5):
  • Low reputation (1):
Posted by: eaDDeN maiLeR