Help

"Find" function not working when referencing rollup field

Topic Labels: Formulas
3113 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Angie_Belle
6 - Interface Innovator
6 - Interface Innovator

I want to assign a numerical value to all recipes that include steps of “Cutting” or “Chopping”, but it doesn’t seem to recognize these or ANY digit/number when using the find function.
Screen Shot 2019-05-13 at 2.23.43 PM.png

3 Replies 3

Hi @Angie_Belle - I’m guessing your roll-up field is an array function. If so, you should make it a string first in the FIND formula by concatenating it with an empty string to get it to work:

FIND("2", Activities & "")

JB

That worked, although I don’t understand why. Thank you! Now, how do I extract the lowest number from an array rollup?

Certain fields, including rollups, generate arrays, not strings. An array is a collection of separate items, and those items could be strings, dates, numbers, etc. However, the FIND function only knows how to find things in a single string. When you ask it to find something in an array, it doesn’t know what to do. Concatenating an array with an empty string (the Activities & "" portion of @JonathanBowen’s sample) forces Airtable to take all of the separate items in the array and mash them together into a single string, which FIND can then process.

One of the aggregation functions available for use in rollup fields is the MIN function, which isolates the lowest value. Enter the following into the aggregation function field when setting up the rollup:

MIN(values)