Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SubTotal

Wagner Romano

Wagner Romano ✭

07/04/16 edited 12/09/19 in Archived 2016 Posts

Is there some way to use subtotal with filters like in Excel ?

Tags:

Sheets

0 ·

Comments

Kennedy Stomps Employee

07/06/16 edited 07/06/16

Hi Wagner-- Good question! We don't currently offer the ability for formulas to auto-resolve based on filtered rows, but I've added your vote for this to our enhancement request list. Thanks for the input!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Why am I not getting a workflow notification email when I trigger the action?
A notification is triggered when I or one other person enters a date in a field. When the other person enters the date, we both receive the notification email; however, when I enter the date, the other person receives the email, but I do not. The other person is the owner, I am an admin if that makes any difference.
Need a better Sheet Summary Formula - (Collect/Max & Index/Match)
In my example, I am able to return the top Sales for an item based on certain criteria for a Sheet Summary formula (Shirt Top Sales) with =MAX(COLLECT(Sales:Sales, Product:Product, "Shirt")). I am also able to return the Color for the Top selling Shirt (Blue) with a formula using the previous summary value in the formula:…
Cross sheet reference - count with multiple parameters
Hello all, I'm looking for advice to write a cross-sheet reference formula. I have two sheets: one list of all students who have completed internships, and a second sheet with a list of organizations where our students have interned. I'd like to pull in a count of how many students interned at a particular site in a…