Formula error

What is wrong with my formula? =SUM(IF({P2F_status_1Q2024 Range 2} = DATE(YEAR(TODAY()), 1, 1), IF({P2F_status_1Q2024 Range 2} = DATE(YEAR(TODAY()), 1, 31), {P2F_status_1Q2024 Range 3} = "billable", 0), 0))


I've also tried this variation, =COUNTIFS({P2F_status_1Q2024 Range 2} >= DATE(YEAR(TODAY()), 1, 1), {P2F_status_1Q2024 Range 2} <= DATE(YEAR(TODAY()), 1, 31), {P2F_status_1Q2024 Range 3} = "billable")


What im trying to do is count the number of items in "P2F_status_1Q2024 Range 3" that are "billable" and have dates within the range of January 1st to January 31st of the current year in SmartSheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!