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

#Value! errors in spreadsheet

デモをリクエスト

hello,

I can't figure out why workiva is throwing a #VALUE! error for the following formulas: 

=IF(ISBLANK($F2),"",INDEX('COA & FSL Mapping'!$B:$B,MATCH($C2&$F2,'COA & FSL Mapping'!$U:$U&'COA & FSL Mapping'!$A:$A,0)))

=IF(ISBLANK($F3),"",XLOOKUP(1,($F3='COA & FSL Mapping'!$A:$A)*($C3='COA & FSL Mapping'!$U:$U),'COA & FSL Mapping'!$B:$B))

Index , Match, and xlookup are all recognized functions, and the formulas work when i export the spreadsheet to excel. 

Any advice ? Thanks.

1

コメント

5件のコメント

日付 投票
  • Liz Walters

    Hi Ashley,

    Thank you for your question!  I believe this is resulting in a value error because Workiva Spreadsheets do not support arrays at this time. However, we do want to add support for arrays in the future. It's not likely that we'll be seeing this in 2023, but I will add you to the feature request so we can notify you about any updates. 

    Cheers!

    0
  • Trang Ho

    Hi Liz,

    thanks for the feedback. Do you know the estimated time when the array formula will be available?

    Thanks

    Trang

    0
  • Mike

    Hi Trang Ho At this time there's no estimated delivery for support of the ARRAY formula, though it does remain proposed with our product team and is on our list of popular items. We'll get you added and will keep you updated here on any progress going forward. Thanks for chiming in and let us know if you have any questions.

    0
  • Kellie Volpicelli

    Hi Mike, do you have any update on when arrays might be supported in Wdesk?  Tks!

    0
  • Isabel Messore

    Kellie Volpicelli,

    Unfortunately, there are no updates at this time but it does remain proposed with our product team - we'll be sure to update you if any progress is made!

    0

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