|
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

Handling of Excel formula in Workiva Spreadsheet

Ukończone
Zamów wersję demonstracyjną

Hi, 

We are trying to automate some Excel spreadsheet consolidation but found that in Workiva certain Excel functions cannot be processed (e.g. MMULT, TRANSPOSE) and would show #NAME? in the cell. For example this formula: 

"=MMULT(MMULT(TRANSPOSE(IF(C13:C16<0,0,C13:C16)),$T13:$W16),IF(C13:C16<0,0,C13:C16))^0.5"

When exporting the Workiva Spreadsheet as Excel, a "@" sign would be added before the function and user would need to manually update the formula in the Excel workbook. Is it possible to build in the Excel function to the Workiva Spreadsheet or to remove the "@" sign when export? Thanks. 

1

Komentarze

Komentarze: 5

Data Głosy
  • Mike Davis

    Hi John!

    Sorry, it took me some time to get an answer sorted for you here. Regarding the formulas, we're looking into getting MMULT and TRANSPOSE added and can add you as a requestor there. I've shared your instance as well regarding the export functionality for Excel and removing the "@" sign. We'll be in touch regarding both. Let me know if you have any questions for me in the meantime.Cheers!

    0
  • Mike Davis

    MMULT and TRANSPOSE are now supported in Workiva Spreadsheets.

    0
  • Crislaine Pires dos Santos

    Hi Mike Davis, 

    When importing my spreadsheet into Wdesk, I’m getting a #NAME? error in the cells containing the following formula:

    =TEXT(EDATE(DATE(YEAR($B$11)-1,10,1),ROW(A1)-1),"mmm'yy")

    Could you confirm whether Wdesk supports all the formulas used in this calculation, or if there are any limitations I should be aware of?

    0
  • Isabel Messore

    Hi Crislaine Pires dos Santos, 

    Thank you for pointing that out! The ROW function is not supported in Workiva, which is likely the cause of the #NAME? error in your formula. You can explore using the SEQUENCE function as a workaround, depending on your specific use case!
    0
  • Crislaine Pires dos Santos

    Thank you Isabel Messore. I solved the issue by using the ROWS function.

    0

Zaloguj się, aby dodać komentarz.