Compare Rollup to function

[ponkreyative]

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?

[TheTimeSavingCo]

Could 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?

[ponkreyative]

Hello. 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.

[TheTimeSavingCo]

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