How to use collect with a parameter

MarcosCruz

Hello:

I have two cell, status and comments. I want a formula that brings the comment when the status is "Delayed". I am trying to use the Collect function, but so far, no success.

Thanks

Paul Newcome

You would use something along the lines of

=IF(Status@row = "Delayed", Comments@row)

If this isn't it, can you provide more details as well as a screenshot for context?