How to do a collect statement against a multi value dropdown?
I'm attempting to do a collect statement from a Matrix which I have.
So for each software there are specific roles within specific departments which need to be trained on the software which is listed in the 'Software' column.
Off the back of the this I have built a tracker to determine when an a specific individual has to be trained on the software from the matrix.
The issue I am having is that it only pulls in the software's which need be trained only if there is a single value in the 'Department' column as opposed to it being multiple values.
Is there a formula to collect all the softwares which training is required on if there are multiple entries in both 'Role' and 'Department'?
Help Article Resources
Check out the Formula Handbook template!