Calculated fields / collections

[MatthewHe1]

Hi there, I'm trying to create a project report that will convey the status of a set of assets by looking at two different tasks per asset and then displaying a custom status depending on the task statuses. I can get information on one task at a time by using a collection in the report, but not both. As an alternative, I'm attempting to create custom fields on the project that would do the same thing, but I'm having difficulty figuring out how to reference tasks in a project calculated field. I'm guessing there's a way to reference a collection in a project calculated field, but I don't see any documentation on this. Any help would be appreciated. Thanks! Matt Matt Henderson Music Audience Exchange, Inc.