I currently have a workflow rule to send an email to the relevant user where no activity has been 'recorded' on a Lead for more than 7 days. It works well but unfortunately it doesn't take into account the case where the user would have set a task in the future (for example a follow-up call or email).

I'm wondering: is there a way to check whether a task has been set in the future for a lead (or contact/opportunity)?

In that way, I could edit the current rule to only send that 'no activity' email where there are no task set already.

Thanks for the help.

Julien