Skip to main content

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.

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.

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!

Reply


Terms & Conditions