Sum Checked Boxes referencing another sheet

Options

Hello, I would like to get a formula that sums checked boxes only and also give me the count based on project status.

This "Metric Sheet" refers to a regular sheet assigned by team member.


Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 03/17/23
    Options

    Hey @Estefania Reyes

    If I understand correctly, you are looking to get the total count of rows that (a) are assigned to the owner at row and have a check box and have a project status of "Complete". Is this accurate? In the formula below, each range is a single column in your source sheet (not the metric sheet). (The formula below is for the Complete project. In the other columns in your metric sheet, swap out Complete for the other respective Status choices)

    =COUNTIFS({source sheet Owner column}, Owner@row, {source sheet Is this a Project? column}, 1, {source sheet Status column}, "Complete")

    Remember you will have to insert each cross sheet reference into your sheet through the formula wizard.

    Is this what you are looking for?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!