Help

Compare Rollup to function

667 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ponkreyative
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
4 - Data Explorer
4 - Data Explorer

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.

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