Need help with Countifs formula

Hi. Can you help me with this formula?

Essentially I want to count the number of positions that have the criteria "Filled" in one column, but also have to have the date 04/17/20 in another column. This formula is not working and I have changed slight variations with commas, "=" and parenthesis and can not make it work. Can you help?

=COUNTIFS({DT Headcount FY21 Range 2},="Filled",{DT Headcount FY21 Range 3},"04/17/20"})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!