Create report formula to count items of certain status but exclude items with future dates?

I'd like to create a formula for a reports that counts the number of items with a specific status (not started, in progress, complete, etc.). However, I'd like to exclude items with a future start date, so the formula should only count items that should have been started already.

Here is the current formula I have. Does anyone know how to update it to add the exclusion?

=COUNTIFS({Project Plan- Status}, [Primary Column]@row, {Project Plan- Children}, 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!