Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Notebook as column

4 replies [Last post]
Tue, 2009-11-24 04:39
Christian Viddal
User offline. Last seen 14 years 46 weeks ago. Offline
Joined: 24 Sep 2009
Posts: 24
Groups: Petro-Chem / Oil & Gas
Hi,

Is it possible to show notebook as a column?
Cannot find this when I browse through the column list.
Only thing I find is to use notes in the Gant chart attached to the labels.


Thanks
Christian
Top

Replies

Tue, 2009-11-24 07:32
#1
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Christian,

You need to assign first the Notebook Topic to your activities (e.g. Anticipated Problems, Corrective Action, Current Status, etc..).

Regards,

Arnold
Top
Tue, 2009-11-24 07:26
#2
Christian Viddal
User offline. Last seen 14 years 46 weeks ago. Offline
Joined: 24 Sep 2009
Posts: 24
Groups: Petro-Chem / Oil & Gas
Thanks a lot for the suggestions from both of you.
Maybe I am blind but when I open the list of available columns I am not able to find Notebook, neither when I am doing the search. Any ideas?

Reason why I need it is when exporting to excel I want to show the notes associated with each of the activities.


Thanks,
Christian
Top
Tue, 2009-11-24 06:15
#3
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Christian,

There is a workaround, create a new report using activity notebook as your subject areas. Open it in excel and then save it.

When done, create a new UDF and display the newly created UDF say, "Remarks". Then go to file menu --> export --> spreadsheet - (xls).

Note: Include the "Remarks" into the column during exporting.

When done, do it in excel by using the "vlookup" function of excel.

Otherwise, email me @ primavera6@live.com

Regards,

Arnold

Top
Tue, 2009-11-24 05:28
#4
Neal Walsh
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 16 Sep 2007
Posts: 49
Groups: Civil Engineering
Hi Christian,

If you Group & Sort the Columns by List, Notebook is there.

Regards,

Walshy
Top