|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

SUM Product formula not working properly with two or more conditions

Ukończone
Zamów wersję demonstracyjną
Powiązane z spreadsheet functions

Hello,

In our Excel, we have several SUM product formulas with two or more conditions. Although Workiva supports the SUM Product formula, it seems it is not supported when it gets more complicated (2 conditions or more) and it causes errors on the upload. 

We have been advised to change the formulas to SUM IF. However, it would be nice to expand Workiva's capacity with more complex forumlas to mirror excel.

3

Komentarze

Komentarze: 3

Data Głosy
  • Oficjalny komentarz
    Mike Davis

    Great news! A recent release to the Workiva Platform has now made ARRAY formulas available which should address this request as well. If you have any questions about this feature, you can visit our Help site or let us know in the Community.

  • Courtnie Carver

    Hello Daniela, 

    Thank you for your feedback. We have created a ticket for our product team to consider this for future implementation.

    You will be updated on the status/progress of your ticket.

    0
  • Catherine Alqallaf

    I've encountered the same issue with sumproduct, and would be happy to see more robust formula functionality within Workiva spreadsheets.

    0

Zaloguj się, aby dodać komentarz.