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

COUNTIFS with an AND
I am trying to use a COUNTIFS formula with an AND. I need to account for two different conditions to determine the count of another column. COUNTIFS the Master - Project Status column is not "complete" AND Master - Sales Stage is "Won" should return a count based on Master - Service from a row. =COUNTIFS({Master - Project…
convert 12 hours time to 24 hour time
Hi, I want to convert 12 hours of time to 24-hour time; kindly help me with this issue.
CountIf between two numbers
I would like to count how many people scored between 99.5 and 99.9. Here is my formual. =COUNTIFS(Janury2:January12; >=99.5; January2:January13; <=99.9)