What is a good substitute for sweet onion in a recipe?

A good substitute for sweet onion in a recipe is yellow onion, which has a similar mild and slightly sweet flavor.