Count Formula

My goal is to determine how many lines in a schedule that are actual task lines (not milestones). So I would need to count any line with the following criteria

"Status" is listed as: Not Started, In Progress, or Complete

"Assigned To" contains a name (or is not blank).


Thanks for any assistance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!