I am also getting issues where the syntax guide is showing me two different places in the syntax at once (see attached pictures). Normally I wouldn't think anything of this, but given that it isn't working, it might be significant.
If I can sort this out, it will let me put text in the value field of a pivot table, which will be HUGE.
Formula I am using is =CONCATENATEX
I just don't know what's going wrong on this, so if any one can shine some light onto the issue, that would be AMAZING!!!
Once again thank you so much!
EDIT: I did get it to work once. That spreadsheet is somewhat unstable and I cannot get it to replicate.
Also, I cannot share the spreadsheet because it contains customer information.