Project Controls

Hello All,

I would like to in P6, view the following in either a report or in excel (export or copy/paste method):

Act. ID      Activity Description        Notebook Topic     Notes

I know that Notes cannot be picked as a a column, and in other drop down lists like group and sort, it isn't there either. Oh, I would like to view only the notes for activities that have them and ignore activities that are not assigned a note.

Has anybody have a clever way to do this?

Thanks