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.