Count Ifs Formulas

Kate
Kate
edited 12/09/19 in Formulas and Functions

I need help figuring out why this formula is returning Invalid Data Type:

 

=COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], MONTH(@cell) <= "3", [Year]:[Year], "2017")

 

I want to count the number of lines that have a Conversion Status of "Won" that also took place in March of 2017

Tags:

Comments

  • L_123
    L_123 ✭✭✭✭✭✭

    It looks like the error was from you having blanks in your date requested column when conversion status wasn't blank. More the fault of the program than your fault, it gets touchy when you mix date and text types in formulas. Use another command to stop it if the date requested is blank

    =COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], ISDATE(@cell), [Date Requested]:[Date Requested], NOT(MONTH(@cell) > 3), Year:Year, 2017)

  • Luke- That's it! I couldn't get the formula to work but when I went back to make sure all of the dates were filled in it didn't result in an error. Amazing-thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!