Using CONTAINS in INDEX/COLLECT cross-sheet formula
Can I use the CONTAINS function within an INDEX/COLLECT cross-sheet formula? I need to pull the Finish dates from a schedule for Tasks that contain a designated text string. There will be multiple tasks that contain that text string. Here is the formula that I have used so far, but I am getting an #INCORRECT ARGUMENT SET error right now. I appreciate any assistance!
Help Article Resources
Check out the Formula Handbook template!