countif if status "in progress" and occurred in the past



I want to create a report that provides the number of items that are "in progress" and their finish date is in the past (past from today). For this report, I have to reference another sheet. This is the formula I'm using but I receive an error message. Does anyone have any idea how to correct? Thank you in advance.

=COUNTIF(reference another sheet, "in progress"), AND (reference another sheet TODAY( -1)).

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!