Summary Task formula for COUNTIF Before TODAY and Status IS NOT "Not Started"


I'm looking for a summary task formula to count a row if the date is before today and Status value is NOT "Location Not Started". I've tried a few formulas and can't get to a working one. This is the last one I tried and getting and "Incorrect Argument" error message:

=COUNTIFS([Confirmed Install Date]:[Confirmed Install Date], <=TODAY(), IF(NOT([Combined Status]:[Combined Status] = "Location Not Started")))

Thank you for your help!

--Lisa M.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!