JOIN COLLECT FORMULA
IN PICTURE (A) i have successful JOIN COLLECT formula
IN PICTURE (B) I tried to replicate the formula, but add additional columns I needed to be joined as well.
IN PICTURE (B1) Incorrrect Argument
Best Answer

Hey @Bobby
The COLLECT function has the syntax of COLLECT(Range where the data is you are trying to collect), Range1, CRITERIA1, Range2, CRITERIA2, etc). The data is always added to the COLLECT function in a rangecriteria pair. The formula B above does not list criteria for any of the ranges.
In Formula A, it says to collect Cost Center data when the Cost Center rows have data on the same row in the [Invoice No] column that matches the current row Unique Invoice .
If you describe the data you are trying to collect, the community can help you with the specific formula.
Kelly
Answers

Hey @Bobby
The COLLECT function has the syntax of COLLECT(Range where the data is you are trying to collect), Range1, CRITERIA1, Range2, CRITERIA2, etc). The data is always added to the COLLECT function in a rangecriteria pair. The formula B above does not list criteria for any of the ranges.
In Formula A, it says to collect Cost Center data when the Cost Center rows have data on the same row in the [Invoice No] column that matches the current row Unique Invoice .
If you describe the data you are trying to collect, the community can help you with the specific formula.
Kelly
Help Article Resources
Categories
Check out the Formula Handbook template!