Hi all,

I have a database with 3 sheets (Sign, Follow, and Corro) that each list different work actions, each with a completed date (column L, H, and J respectively).

I want a pop up alert on open that lets me know how many actions are yet to be completed on each sheet:

You have outstanding actions!
Sign #
Follow #
Corro #

I know how to do pop ups on open, but I'm not sure how to incorporate a function that counts the amount of 'unfinished' actions on multiple sheets.

Any help would be appreciated