クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

Argument to specify Unique values in TEXTJOIN() Function in Wdesk Spreadsheets

1

コメント

5件のコメント

  • Brandon Ehrecke

    Hi Stephen!

    Thank you for sharing this feedback! We have shared your suggestion with our product team and you will be updated if anything changes regarding this. Anyone passing by is also encouraged to vote up/comment on this suggestion. Let us know if you have any questions in the meantime. Thanks!

    0
  • Stephen Brillhart

    Awesome! Thank you very much.

    0
  • Mike

    Hi Stephen!

    One workaround that I came upon in the interim could be to use TEXTJOIN in conjunction with IF, AND or OR functions, which are also supported in Workiva. I've not personally created this combined function, but a pass through the annals of Google provided some tips on it. Wanted to share that. Thanks for your suggestions!

    0
  • Stephen Brillhart

    Thanks for the tip!  I have been able to get what I needed done using IF, AND, and OR, but the formulas are pretty ugly and not easily readable.  This suggestion was more for aesthetic/reproducibility reasons.  Thank you for all of this feedback though!  I honestly didn't think I would get this much feedback so quickly.

    0
  • Mike

    You're quite welcome. And thanks for the kind words. We aim to please 😊

    0

サインインしてコメントを残してください。