Array Formulas
CompletedDoes Workiva support array formulas in the spreadsheets? I uploaded an excel workbook that uses array formulas and I cannot seem to get my formulas to calculate in Workiva.
-
Official comment
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!
Welcome to the Community, Joey!
At this time, Spreadsheets do NOT allow the use of array formulas. You are not the first to request this, however, and I've added you the list of interested customers. You can stay up-to-date on progress here, but I'll also update this post as well. Thanks for your input and let me know if you have any questions. Cheers!
1
Please add me as a requestor as well. Thank you.
0
You got it MD! 👍
P.S. Those are also my initials 😊
0
Quick update here. At this time, work is not planned for this feature enhancement. We'll continue to keep taking in requests here, though, so let us know by a comment or vote if you would like this feature and we'll keep our Product Team informed. Should anything change, we will re-open this request and let you know.
Many thanks, and have a great rest of your day!
1
Please add me as a requestor as well. Thank you.
0
Hi Mike,
Can you please add me as a requestor on this item?
Thanks!
0
Got you both Kellie Volpicelli and Joseph Pisaturo 👍
0
Please add me as a requestor as well. Thank you.
0
You got it, Denise!
0
Please add me as a requester as well. Thanks
0
Done, Abu!
0
Please add me as a requestor as well. Thank you.
0
Please add me as a requestor as well. Thank you.
0
Hi Mike,
I was just wondering if any of the additional requestors on this item have moved this up the production "wish list".
Thanks!
0
Hi Joseph!
I can definitely say that the additional requests we've continued to get on this enhancement has definitely propelled it into the list of items we are proposing for work next quarter. I am hopeful it could get picked up for Q1, or at the very least earmarked to be worked on at some point in 2022. I'll definitely let you know where it lands.
0
Hi Mike, please add me as a requestor for this also. Trying to use an array with a SUMIFS formula.
0
Hi Mike, please add me as a requestor for this also!
0
Hi Mike, please add me as a requestor for this as well. Thank you!
0
Please add me to the request as well. Thanks!
0
Would definitely appreciate as well.
0
I am trying to use SUMPRODUCT formula with arrays, but unfortunately it is stuck as well. It is one of the very powerful formula from usage perspective. Kindly add to the request as well. Thank you.
0
Please add me also. Thank you.
0
Great news! Thanks to your perseverance, support for array formulas has been resurrected and is now on the future product roadmap. I don't have any specific timelines for when this could be worked on but this is a step in the right direction, for sure. Many thanks for your feedback and patience. We'll continue to take requests here and will keep ya'll apprised of any developments. Thanks again and have a great day!
1
Please also add me to the requestor list - this would be incredibly helpful to our organization.
0
It's a deal, Alex!
1
Please add me to the requester list! Thanks.
0
You got it, Julia!
0
Comments
35 comments