No, you can not reference a collection in a calculated field. So logically speaking, I think you want to go from a task to the project level and then grab the custom form data value from a specific data field and compare that to the value field in the original task. I do think that it's technically ...

HI John, An IF statement always requires three parts 1. Comparison to check 2. Result when 1 is true 3. Result when 1 is false 2 and 3 can be other IF statements if you want, be each IF statement needs all three components. You do not have all three for all three IF statements. Also, since you're re...