Wondering if someone can help me figure out the following:
I have a variable that could populate with various information such as "1K to 3.5K" or "1K to 10K". The goal would be that if this variable includes anything under 10K, or less, another field is populated with 1K to 10K. I tried to use the "ContainsNumber" and IsLess formulas but I can't figure out how to put them together. There is probably another way I should be creating this statement so I thank you in advance for helping me out.
Best answer by john_armstrongView original