
Mar 10, 2014
Microsoft Project allows you to customise fields for several purposes including; to save time, avoid typing errors, meet stakeholders' expectations and needs, warn you that a task is due in a certain number of days, or to meet reporting expectations. Customised fields can perform simple and complex calculations, similar to functions in Excel. In Project, you can also add drop-down lists with options so that the user can select from a list rather than manually type in data. There are 9 custom fields that you can add in Microsoft Project. These include cost, date, duration, finish, flag, number, start, text, and outline code. Note that all field types allow you to add 10 customised fields with the exception of the 'text' field, which allows for 30 customised fields. Let's say, for example, you want to calculate the GST on the resources' standard rates. To do this in Microsoft Project, you will have to firstly, create a cost customised field and add it to the 'Resource Sheet.' To do this, follow the steps below:- Open the Project file and go to 'Resource Sheet' view.
- Click the 'Project' tab (or Resource Sheet Tools Format).
- Click the 'Custom Fields' button in the 'Properties' group (or columns group respectively). Since you are in the 'Resource Sheet' view, the Resource option is already selected.
- Select the 'Cost' type and then select the 'Cost 1' field.
- Rename this field to 'GST.'
- Click the 'Formula' button.
- Using the 'Field button', select the 'Cost – Standard Rate' option and click the asterisk (*) button.
- For GST, you'll need to multiply the Standard Rate by 10% so type in '0.01.'
- Click OK. The message displayed is warning us that the existing data will be deleted. Click OK again.
- Select the 'Ovt.Rate' field.
- Press the 'Insert' button on the keyboard.
- Type “GS” and Microsoft Project will select the GST field (rather than you scrolling down the list).
- Click on this and the GST field will be added to your table.
How do your Excel skills stack up?
Test NowNext up:
- Monetise your Windows Store Apps
- “Hey Rocky, watch me pull a rabbit out of my hat!” said Bullwinkle the trainer
- What's new in SQL Server 2014 Database Development
- Where did my Acrobat tab go in Microsoft Word?
- Enhancing the IF function with nested IF functions in Microsoft Excel
- What's new in SharePoint 2013 for developers
- Think Leader. Think Legacy. Think Auntie Marg.
- SQL Server 2014: In-Memory Database Capabilities
- How to create a PivotTable using Excel VBA
- Database indexing issues in Exchange Server 2013
Previously
- Make CSS3 animations stay put after they've performed
- Data Deduplication in Windows Server 2012: The Solution for Ennui!
- Leonardo, Steve and Basil
- Creating Building Blocks in Microsoft Outlook
- A Closer Look at Excel PowerPivot and Power View
- How to sort lists with multiple levels in Excel
- What Lies Beneath - Part 2
- No wonder my sales were down; I thought AIDA was an Italian Opera!
- Get-Help – the PowerShell Way
- Saving a file with a unique name in Excel VBA