Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

#Value! errors in spreadsheet

Request Demo

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

Comments

5 comments

Date Votes
  • 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

Please sign in to leave a comment.