#Value! errors in spreadsheet
Ukończonehello,
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.
-
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
Hi Liz,
thanks for the feedback. Do you know the estimated time when the array formula will be available?
Thanks
Trang
0
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
Hi Mike, do you have any update on when arrays might be supported in Wdesk? Tks!
0
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
Hi all!
Wanted to share here that ARRAY formulas are now supported in Workiva. More information can be found here on our Help site. Thanks for your feedback and patience along the way. We couldn't have done it without you!
1
Komentarze
Komentarze: 7