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

SUBTOTAL does not allow Function_num that "ignores hidden rows"

完了
1

コメント

4件のコメント

  • 正式なコメント
    Isabel Messore

    Great news! A recent release has added some upgrades to our SUBTOTAL formula, notably that it now supports the hidden ell operators 101 thru 111. By default, this functionality is enabled though there are some caveats (listed below). New files or embedded tables will automatically upgrade to this formula version and any existing files (including copies) will be automatically upgraded to this formula version. Should you run into any scenarios where your formula is impacted by this change and not yet upgraded, you can reach out to your CSM or our Support team and they can assist in getting those migrated.

  • Courtnie Carver

    Hello Pedro, 

    We have had questions about this in the past which you can view here.

    The good news is that this enhancement has already been added to the future roadmap. No specific timeline to share as of yet, but it's a step in the right direction. We will get you added to the list of supporters for this feature and you will be updated with any progress/updates. 

    Thank you!

    1
  • Jennifer Flores

    Hi, since the SUBTOTAL formula is not currently an option,  is there another way to get the same end-result? 

    0
  • Pedro Andrade

    Hi Courtnie,

    Thank you for your prompt reply.

    I guess I've just come around a way to double check if there are hidden rows in the meantime we wait for the Subtotal enhancement.

    Yes, please add me to the list of supporters for this feature! ;)

    Regards,

    0

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