I'm trying to create a custom view that would show a salesperson's leads with a column that shows the due date of the next activity associated with that lead. I'm especially looking for the salespeople to be able to see which of their leads have no next associated task, and I would like to display this on the homepage rather than creating a separate report that they would need to access.

Does anyone have any ideas how I can do this?

Thanks!