Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

SUBTOTAL does not allow Function_num that "ignores hidden rows"

Voltooid
1

Opmerkingen

6 opmerkingen

  • Officiële opmerking
    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
  • Pedro Andrade

    Dear Isabel Messore, thank you for your update.

    Although, it seems there is a bug on the recent release as I still get error messages when trying to use 109 code. I keep getting the "#VALUE" error message everytime.

    Please advise on how can I get support for this issue.

    Regards.

     

     

    0
  • Liz Walters

    Hi Pedro,

    Happy Friday! I am going to connect you with our Support team so that they can investigate this further. They'll likely ask to see a screenshot of the formula so they can help troubleshoot it. I've opened a ticket for you and our Support team should be reaching out to you shortly.

     

    0

U moet u aanmelden om een opmerking te plaatsen.