Hi Community, working with an index/collect formula and in need of some help.
Members from various committees complete a form and when submitted, it comes into one intake sheet. On separate committee sheets where the members name is already in place, I want to show when they submit their form (matching the first name and last name) and the checkbox will check if completed or stays empty if they haven't submitted the form yet. I have this formula:
=INDEX(COLLECT({CA_Form_cmp}, {CAForm_FName}, [First Name]@row , {CA_Form_LName}, [Last Name]@row ), 1)
The screenshots below show the formula appears to be working when someone submits their form. But if someone hasn't yet submitted their form, instead of an empty checkbox appearing in the committee sheet, the cell has #invalid value. Am I missing something in my formula? Thanks in advance!
