CountIFS

JiMel
JiMel ✭✭
edited 02/28/24 in Formulas and Functions

I can't figure out what is wrong with the formula below, looking for some assistance.



Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Can you provide some screenshots of the relevant columns or error (if any)?

    Without that, my best guess is that your Range 1 is a date column and your Month@row is not. If this is the case, you would need to to alter the Month column (or add a helper column with a month number if text) to make it more along the lines of:

    =COUNTIFS({Internal Audit Schedule Range 1},IFERROR(MONTH(@cell),0)=Month@row,{Internal Audit Schedule Range 2},"Complete On Time")

    Hope this helps, but if any problems/questions, let us know!

  • JiMel
    JiMel ✭✭

    Nick, below is the error I'm getting.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!