Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Perform a search off of a rollup?

Topic Labels: Formulas
Solved
Jump to Solution
394 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I have a rollup field (called “Lessons Included”) that won’t work in the following formula:

IF(AND(FIND(“Math”, {Lessons Included}), {Submit Date}=BLANK()), “Math Pending”,
IF({Submit Date} = BLANK(), “Math Not Included”,
DATETIME_DIFF(
{Materials Due},
{Submit Date},
‘days’)))

The FIND doesn’t work, and all fields where Submit Date is blank return Math Not Included, even if Math is part of the rollup field. Any ideas on a workaround for this?

UPDATE: If I create a helper lookup column that includes ONLY “Math”, I can get the formula to work. However, with all the lesson types included, that would make my sheet much larger than it currently is.

1 Solution

Accepted Solutions

Is your Rollup producing an array or a string? If its an array usually you could do {name of field}&"" to force the FIND() formula to recognize it as a string.

See Solution in Thread

2 Replies 2

Is your Rollup producing an array or a string? If its an array usually you could do {name of field}&"" to force the FIND() formula to recognize it as a string.

Works like a charm!!! I didn’t know about the array to string recognition. Thanks so much!