Sheet Summary Fields

Special fields at the top of every sheet (outside row data) that can contain formulas aggregating the whole sheet. Ideal data sources for dashboard metric widgets.

Syntax

smartsheet-mastery

Smartsheet icon (top-left) → Sheet Summary → + Add Field

Example

smartsheet-mastery

// Sheet Summary formula examples:

Total Tasks:         =COUNTA([Task Name]:[Task Name]) - 1
Complete:            =COUNTIF([Status]:[Status], "Complete")
At Risk:             =COUNTIF([Status]:[Status], "At Risk")
Overdue:             =COUNTIFS([Due Date]:[Due Date], <TODAY(), [% Complete]:[% Complete], <1)
Budget Remaining:    =SUM([Budget]:[Budget]) - SUM([Actual]:[Actual])
Avg % Complete:      =AVG([% Complete]:[% Complete])