Task Info On Program Report

Hi Sarah,

Without trying the code myself, I'd guess the answer is yes, if it worked on a project level report it should work on a program level report with some minor changes...

For example, you'll want to preface the field names with {project}.{tasks}.{name}

Like this:

IF(CONTAINS("Receive fully executed LOI and save in LF",{project}.{tasks}.{name}),IF(ISBLANK({project}.{tasks}.{actualCompletionDate}),"","Yes"))

Let me know if that works for you.

Best -

Teale

Hi Sarah,

Unfortunately, you won't be able to reference the task information from a program report.

Tasks are 2 objects (program>>projects>>tasks) away from the main object (program). When referencing collections in a column, you can only reference 1 object (program>>project) away from the main object (program).

If it works for your case, you could start with a report at a Project level, reference up to the Program and then reference the Tasks collection, or you could create a Task report and reference up to the Program.

Thanks,

Dan