Join Distinct Collect - incorrect argument set

Rebecca Menning

Any suggestions on why the below formula is generating incorrect argument set error?

=JOIN(DISTINCT(COLLECT({CPA Range 1}, {Supervising}, {CPA Key}, [CPA Key]@row)))

Thank you !

Becky

Andrée Starå

Hi @Rebecca Menning

I hope you're well and safe!

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Rebecca Menning

Andree,

I have granted access to the test files. Attached is a summary of the objective. Your review is appreciated.

CPA Join Error.docx

Christina09

@Rebecca Menning

You're missing a criterion

=JOIN(DISTINCT(COLLECT({CPA Range 1}, {Supervising}, {CPA Key}, [CPA Key]@row)))

Here's the breakdown of your formula:

{CPA Range 1} = range

{Supervising} = criterion_range1

missing criterion1

{CPA Key} =criterion_range2

[CPA Key]@row =criterion2

Rebecca Menning

Thanks Christina. Unfortunately, we (as in a group of us) are still not able to successfully complete this formula. Does Smartsheet offer 1:1 support?

Becky

Andrée Starå

Hi @Rebecca Menning

I hope you're well and safe!

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Rebecca Menning

If your plan has purchased Pro Support, you can book 1:1 coaching sessions over screen share (see Professional Support Package)

If you're still having issues with the formula, could you post what you're currently working on, the error (or incorrect result) that you're seeing, and a screen capture of the Source Sheet with the columns noted that you're looking into? (But block out sensitive data).

Thanks!

Genevieve

Rebecca Menning

Andree,

I have granted access to the test files. Attached is a summary of the objective. Your review is appreciated.

CPA Join Error.docx

Rebecca Menning

Thanks Andree for the conversation. Preliminary testing shows your correction is working!

Andrée Starå

@Rebecca Menning

Excellent!

Glad we got it working!