The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Project Training and help » Creating expressions for non-default columns

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Creating expressions for non-default columns

Resolved · Low Priority · Version 2007

ReplyFri 5 Mar 2010, 16:38Delegate Camilla said...

Creating expressions for non-default columns

How do I create if expressions for non-default colunmns?

For upcoming training course dates see: Pricing & availability

ReplyMon 8 Mar 2010, 10:17Trainer Andrew said...

RE: Creating expressions for non-default columns

Hi Camilla

Thank you for your question. You can access fields that can be customised by going to Tools > Cusomize > Fields.

By choosing a field type (e.g Text) and selecting one of the available fields (e.g. Text1) you can set a formula that incorporates and If expression. Click on the Formula... button and then click on Function. From the General sub menu choose IIF (this is the equivalent of an IF Function)

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Mon 15 Mar 2010: Automatically marked as resolved.

MS Project articles

· Set The Right Start Date In Project
· How To Track A Project Plan In Microsoft Project 2003/2007
· An Introduction To Microsoft Project
· Find Out About The Power Behind Microsoft Project
· Tools To Keep You On Track With MS Project

Please browse our web site to find out more about
microsoft project server/central and other Microsoft training courses.

Ms project tip:

Using the Quick Access Toolbar in Project 2010

The Quick Access Toolbar is included in virtually every Office product, including Project 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all MS Project hints and tips

How do I indent a table of contents without messing up the table? When I use the increase indent button, each line goes over to two lines, even though there is space for an indent.

» Forum post: Indenting a table of contents

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions