Forum Discussion
Solved
IF statement that references a table
I'm having trouble getting a lengthy IF statement to work, and I believe it needs to come from a table (or be one really long formula). I have reports that do not include team alignment with tea...
Hi CoreyCarson,
Check if the attached file solves your query
CoreyCarson Are your team leaders and support persons are related to each other based on some common criteria such as same Department/Division, same Project, etc.? If they are not and randomly assigned to each other instead, you will have to create different sets of team leader-members then use formulas to look up.