Another formula question


I was trying to do a count for how many fire drills in each month. I have already done helpers for monthly and have a separate column for fire drills. This is the formula I have, can anyone help?

Best Answer

  • Victoria_Indimar
    Victoria_Indimar ✭✭✭✭✭
    Answer ✓

    Hello! You would need to use the COUNTIFS since you're checking for two pieces of criteria.

    Please try: =COUNTIFS(Monthly:Monthly,status@row,[Fire Drill]:[Fire Drill],true)

    Or since it looks like you have references: =COUNTIFS({Monthly},status@row,{Fire Drill},true)

    Hope this works. Please let us know!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!