What formula would I use to find the Task Name(Column 1) with the soonest due date?
I set up a checkbox Helper column to be checked if the Status column of the task is "not started" or "in progress". I would like the sheet summary to reference the Task Name with the soonest date in the Due Date column if the Helper column is checked. Is there a formula that would accomplish this?
Help Article Resources
Check out the Formula Handbook template!