Help with how to sort data, summary, report, formula?? Not sure

Options

I would like to filter, sort, and/or summarize (not sure which option) to see who has check marks in three or less of these columns.


Answers

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    Options

    @Kris Peeters

    Would recommend doing a helper column with a count if any of those row are checked, then doing the filter off, is less than or equal to 3.

    =COUNTIF([Left most column name]@row:[Right most check box column name]@row,1)

    This will sum all of the checked fields into a single digit.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    edited 05/30/23
    Options

    One option would be to add a "helper" column. (It could be hidden)

    Use: =IF(SUM([Teaching Methods 52]@row:[Reflections on your Instructional Practices]@row) => 3, 1, 0)

    Make that a column formula and format as a checkbox. (I'm kind of guessing at that last column name)


    You will then be able to add a filter to only display rows where the helper column is checked.

  • Kris Peeters
    Kris Peeters ✭✭✭✭
    Options

    @Colleen Patterson it worked! Thank you!

    =COUNTIF([Curriculum & Course Design 50]@row:[Data & Evidence Analysis]@row, 1)

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    Options

    @Kris Peeters Glad to be able to help! Feel free to tag me in future requests as well.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!