I am trying to create a formula that counts anything under 8 days in a column but by month and Fiscal year as well. Below is what I created and I get an unparseable error. Any suggestions?

=COUNTIFS({Depot Repair Collection Log Range 8}, <8, {Collection Repair Log Range 6}, "4", {Depot Repair Collection Log Range 4}, "FY2024))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!