Forum Discussion
deldridgdeldrid
Qrew Trainee
Because [Number of Activities] is a text field, your formula compares the values like it compares text... i.e., in alphabetical order, not numerical order. Consequently, "1" < "10" < "2" < "3", etc. You might try creating a new formula-numeric field [Number of Activities - numeric] with the formula
ToNumber([Number of Activities])
and set your dynamic formula rules to use it instead of the [Number of Activities] (text) field.
deldridgdeldrid
5 years agoQrew Trainee
Glad to help!