I was going through the PLANUAL and noticed this error. I think the formula is wrong.
If majority items in a list are blank then it should be:
- IF ISBLANK(Line Item) THEN BLANK ELSE FINDITEM(List, line item)
Also, is it efficient to use ISBLANK() in conjunction with FINDITEM() OR a better approach could be using a Boolean?
Line Item 1 = ISBLANK(Line Item)
Line Item 2 = IF Line Item 1 THEN BLANK ELSE FINDITEM(List, line item)
