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.
Locking a Summary Row
Options
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
Comments
-
While it isn’t possible to have a row that shows a summary of filtered data, there are formulas such as SUMIF and COUNTIF that will sum and count only cells that meet a criteria you specify. If this is what you are looking for, check out this Help Center article on formulas: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas
This discussion has been closed.
