#IMPARSEABLE error message a column with specific date from another column

My goal is to collect all of column "Estimated # of grp mem (not including fac)" for dates that begin 1/1/23 and after which are located in column "Date Form Completed".

I've tried it with COUNT and COUNTIFS without success. Is there a piece I am missing?

=COUNT(([Estimated # of grp mem (not including fac)]:[Estimated # of grp mem (not including fac)], [Date Form Completed]:[Date Form Completed], >=DATE(2023, 1, 1))

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!