I am using MSP 2010 and not sure if I am imagining this but wonder if this is possible.
I want a flag to go to yes based on a user input for example if the user input is 10 the flag will go to yes where the numeric field shows 10 or any number that the user has selected. Is this possible?
Thanks for that, which is what I am doing. What I want is the flag to change depending on what number is selected. For example in a numeric field I have items marked 1-5, there will be many number 1’s, 2’s etc, but I have one flag field. So the formula would have to reflect a value the usrt has selected so if they pick 1 the flag will say yes for each occurrence of 1.
So I am trying to find out is there a way the formula would re-write itself based ona value selected by the user.
Maybe I do not fully understand what you desire.
You can make a Flag field change by using this formula for example:
(If Number1=1,YES,NO). Instead of the NO expression you can use also nested Ifs. Just insert the same expression for the NO statement and alter the number that also should turn the Flag field to YES.
If this is not quite what you want, maybe consider using several Flag fields instead.
I don’t think you can make a custom field formula dependent on user input. From what you’ve written, each task has a number assigned either manually or with a formula, say in the Number1 custom field. You would like to automatically flag (using Flag1) only those tasks whose assigned number matches some selected criterion.
This is easiest to do using vba. For example, the following procedure opens an input box and asks which value (in the Number1) field you would like to flag. Then it sets Flag1 to “Yes” for all tasks whose Number1 matches the selection (“No” for all others.)
Dim t As Task
Dim k As Long
k = InputBox("Enter Number to Flag")
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
If t.Number1 = k Then
t.Flag1 = "Yes"
t.Flag1 = "No"