Can COLLECT Criteria use text values?
I am trying to find the earliest date in a range of dates. But I only want to consider dates that have a certain text value in a corresponding cell.
Here is the formula I'm trying to get to work:
=MIN(COLLECT([Prod Date 1 (copy)]@row:[Prod Date 8 (copy)]@row, [Prod Date 1 - (ON / OFF / DARK / LIVE) (copy)]@row:[Prod Date 8 - (ON / OFF / DARK / LIVE) (copy)]@row), ="ON/LIVE")
[Prod Date [n] (copy)] range are dates
[Prod Date [n] - (ON / OFF / DARK / LIVE) (copy)] range are text
I get an "#INCORRECT ARGUMENT SET" error with this formula.
Would appreciate any help on what I'm doing wrong here.
Help Article Resources
Check out the Formula Handbook template!