Project Plan Reports

Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible?

If not, is there a formula that pulls the task name that I can do?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!