Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2016, 10:44 AM
ProjectCalcs ProjectCalcs is offline Need to default the Cost Column based on another column's value Windows 7 64bit Need to default the Cost Column based on another column's value Office 2010 64bit
Novice
Need to default the Cost Column based on another column's value
 
Join Date: Sep 2016
Posts: 1
ProjectCalcs is on a distinguished road
Question 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!
Reply With Quote
  #2  
Old 10-03-2016, 07:02 AM
JulieS JulieS is offline Need to default the Cost Column based on another column's value Windows 7 64bit Need to default the Cost Column based on another column's value Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Tags
cost

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to default the Cost Column based on another column's value average column based on sum of 2 columns rafnews Excel 4 12-12-2014 09:32 AM
Need to default the Cost Column based on another column's value 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft