Rollup + IF(SEARCH())

[Jeffrey_Brandt]

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.

[Kamille_Parks · Accepted solution]

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.

[Jeffrey_Brandt]

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