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.
