Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

SUMIFS on columns

I'm looking to sum the values in the duration column, if the row is not marked as a bug (this is a checkbox column) and if the district name matches a value (in this case Muskogee).

This is what I've come up with and it's not working:

=SUMIFS(Duration:Duration, [District Name]:[District Name], "Muskogee", [Program Bug/No Charge]:[Program Bug/No Charge], "0")


Help :(

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions