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

how to automatically set a number to an entry
Hi All, I'm trying to make an equation wherein if I type "Critical" in column 1, column 2 then will automatically assign it as "priority 1"
Sum(IF(ISDATE
Can this statement work. Getting a syntax issue. =IF(ISDATE([Plans To Field Date]@row]@row), Sum(IF(ISdate([Slab Inspection]@row), 1, 0), IF(ISDATE([Frame Inspection Date]@row), 1, 0), IF(ISDATE([Cabinet Install Date]@row), 1, 0), IF(ISDATE([Final C.O. Date]@row, 1, 0) + 7)), SUM(IF(ISDATE([Spec Release Date]@row), 1, 0),…
How to count multiple values in the same column
Background info : Product name is MR/HV13 This product has 4 types (MR/HV1375, MR/HV1385, MR/HV1395 and MR/HV13115) I would like to count how many entries of each of the product types were submitted and total them under the mother product name which MR/HV13 Initially, im using COUNTIFS and planning to do a monthly data…