クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

Handling of Excel formula in Workiva Spreadsheet

計画済み
デモをリクエスト

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

コメント

1件のコメント

日付 投票
  • Mike

    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

サインインしてコメントを残してください。