Help

Perform a search off of a rollup?

Topic Labels: Formulas
Solved
Jump to Solution
1562 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeffrey_Brandt
6 - Interface Innovator
6 - Interface Innovator

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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!