Fantastic!
Can you explain to me what is different about the formula you wrote that got rid of the error message? I deleted my old formulas but pretty sure at least one version I tried had the ISNUMBER function instead of ISBLANK, and it still didn't resolve the error message issue.
Thanks.