Hello.
I am trying to find records where a rollup results is less than or equal to a function. Both are formatted as numbers, and both work when I search for records in each column independently. Is there a solution for this?
Compare Rollup to function
+5
+31Could you provide screenshots of the formulas used in your fields, as well as the error you're facing? Perhaps try wrapping the formulas with a "VALUE()" to make them numbers?
+5Hello. Thank you for responding. I eventually learned that Airtable does not support the route I was taking, as it required comparing two different field types. The Value function did not work either. I had to create fields that required the user to manually enter the data I needed on signup, which is not that big of a deal.
+31Hello. Thank you for responding. I eventually learned that Airtable does not support the route I was taking, as it required comparing two different field types. The Value function did not work either. I had to create fields that required the user to manually enter the data I needed on signup, which is not that big of a deal.
Roger that. For what it's worth, I've had success just adding a "+0" at the end of formulas to make them numbers too
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.