How does COLLECT() with String Criterion Work?
I have a simple formula (I thought) that seems to broken. It seems to be centered around the existence of a String in the Criterion Parameter of COLLECT().
Formula: =IF(MIN(COLLECT(Date:Date, [Work Type]:[Work Type], "Mandatory"))=Date1, Hours1-6, Hours1)
Is it not possible to have a string Criterion like "Mandatory" in COLLECT()?
Help Article Resources
Check out the Formula Handbook template!