Jul 13, 2021 02:23 PM
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.
Solved! Go to Solution.
Jul 13, 2021 02:54 PM
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.
Jul 13, 2021 02:54 PM
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.
Jul 14, 2021 07:08 AM
Works like a charm!!! I didn’t know about the array to string recognition. Thanks so much!