So I recently created my first foundry mision, "Proving Grounds" and it won't show up in game or otherwise. Is there a waitng period or something of that nature?

it goes into a review section until 5 people have reviewed it first.

if you click become a reviewer down the bottom of the foundry tab you will be able to search for it.

You'll get a PM when it's published