I am trying to get a unit count between a date range.

Options
chaczef
chaczef
edited 05/03/24 in Formulas and Functions

I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula?

This is the formula I am using:

=COUNTIFS({15-ImpDate}, >=[Start Date]@row, {15-ImpProdHr}:{15-ImpProdHr}, >"0") + COUNTIFS({15-ImpDate}, <=[End Date]@row, {15-ImpProdHr}:{15-ImpProdHr}, >"0")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!