collect with conditional statement to return all values
I am attempting to use a collect with no criteria, that is it grabs everything and am having some problems.
=JOIN(COLLECT(Return:Return, a:a, IF(ISBLANK(a10), true)))
my desired behavior is that if cell A10 is blank, all of the values of Return (including where A is blank) are collected.
This is part of a much larger equation that will allow for user sorting for some basic data analysis and chart building.
is the sheet that i've been trying to get this to work on.
Help Article Resources
Check out the Formula Handbook template!