Sign in to submit new ideas and vote
Get Started

COUNTIF or SUMIF Formula in Report Summaries

Kelly Leal
Kelly Leal ✭✭
in Smartsheet Product Feedback & Ideas

Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric page.

ReportFormula.jpg


Tags:
Share on FacebookShare on Twitter
4
Up
4 votes

Idea Submitted · Last Updated

Comments

  • Adrian Mandile CHESS
    Adrian Mandile CHESS ✭✭✭✭✭

    If you include a Checkbox column In a Report, and want to use it for a Summary, it only offers the COUNT summary type and counts ALL the checkboxes regardless of whether they are ticked or not.

    However, it would be great if we could also have the SUM summary type made available, which would ADD the checkbox values – i.e. a sum of the "1" values in TICKED checkboxes ONLY.

    · Share on FacebookShare on Twitter
  • Sue Hill
    Sue Hill ✭✭✭✭

    Agree need this feature in reporting, counting checkboxes in a column

    · Share on FacebookShare on Twitter

Categories