Here is the Employees List. You can see the List Subset Boolean Column
And here is the Blueprint for my Module:
The goal is to get the Line Item called 'Defined in Active Subset?' to reflect the Booleans of the List Subset.
The FINDITEM will be attempting to find an Employee, based on Code, in the List Subset.
The ISNOTBLANK will set the Boolean to True if they are there. This all works if I use the Formula you can see in the screenshot. But that gives me a TRUE for all Employees. I need it to be True for just the Employees included in the Subset.
Ah I see it now. There is an extra space in your original formula after the colon right? So should be: isnotblank(finditem('#E2 employees: Active?', code)) instead of isnotblank(finditem('#E2 employees:Active?', code))
Thank you for your help! That was way too hard to troubleshoot!
The baffling thing was that I was unable to accomplish this formula using the "click to select" method. Could I have done that this whole situation could have been avoided.
To test it out I tried renaming the subset to just "Active." Seeing if there were characters in the subset name that were stopping me from clicking on it. Same result. Clicking on the name of the subset (from this view) doesn't work for me when filling in a FINDITEM function:
I can click on 'Display Name' and it goes into the formula. But not on '#E2 Employees: Active?'
Yeah you're right, there's no way to undock and click into list subsets but that would be nice. Usually what I'll do is go directly to this list, double click into the subset line and copy it (being careful not to change the name), and then go to my formula line item and paste it directly in. Less room for error. Another recommendation I would make would be avoid special characters in the naming convention. I usually try to stick to "SS Active Employees" or maybe "SS Active Employees?" just because this gives me less room for error (especially after a long day).
Glad this helped resolve and apologies for the confusion on my responses, took me a bit to catch. Have a good weekend!