Forum Discussion
EvanMartinez
6 years agoQrew Elite
Hi Kirby,
One thing that can regularly throw off colorization formulas that are using matching text can be when a formula calls the value and is missing or has extra spaces. What is open helpful to do is to check the multiple choice field to see if any of the entries have a leading or trailing space and if it does make sure that is also captured in the formula. So for example if it isn't colorizing "At Risk" it could be because the entry is actually "_At Risk" or "At Risk_" with that dash representing a space somewhere in there and since you are using an equal to Quick Base isn't considering them exactly the same even though just looking at it casually they appear to be equal. When working up a formula I have had that catch me a few times.
The other trick is to wrap the field tag in a Trim function that would cut off any extra spaces Trim([Budget Status])="At Risk
One thing that can regularly throw off colorization formulas that are using matching text can be when a formula calls the value and is missing or has extra spaces. What is open helpful to do is to check the multiple choice field to see if any of the entries have a leading or trailing space and if it does make sure that is also captured in the formula. So for example if it isn't colorizing "At Risk" it could be because the entry is actually "_At Risk" or "At Risk_" with that dash representing a space somewhere in there and since you are using an equal to Quick Base isn't considering them exactly the same even though just looking at it casually they appear to be equal. When working up a formula I have had that catch me a few times.
The other trick is to wrap the field tag in a Trim function that would cut off any extra spaces Trim([Budget Status])="At Risk