#1
|
|||
|
|||
Need to default the Cost Column based on another column's value
Hi everyone,
I am working with MS Project and have a custom text field populated with one of three values in that fiekl - Pre-Implementation, Implementation, or Post-Implementation. I need to automatically populate the cost column with either 1, 2, or 3, depending on teh selection in the custom text field. Is there a way to do this? Alternatively, I could have the custom text field column automatically highlight the row or a value in the row, if the cost column is empty. I don't know how to do either so any help would be appreciated! |
#2
|
|||
|
|||
The cost field is calculated by Project and you cannot change that calculation. However, there are 10 spare cost fields that you can use to calculate a value.
Regarding the custom text field highlighting a row - not without code (VBA for example) to set the background color. |
Tags |
cost |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
average column based on sum of 2 columns | rafnews | Excel | 4 | 12-12-2014 09:32 AM |
Need help on duplicates in column; deciding which to keep based on other column | nwcf | Excel | 3 | 01-31-2014 09:43 AM |
Which column shows just labor cost? | ketanco | Project | 9 | 06-20-2012 02:19 PM |
How to rename cost column | ketanco | Project | 3 | 06-15-2012 03:06 PM |
free slack changes when i paste from fixed cost to cost1 column | ketanco | Project | 5 | 02-03-2012 06:17 AM |