What I Did
I created an invisible link as the first item in my dropdown and repositioned the dropdown higher to create the illusion of clicking on the folder link.
Disclaimer: I have no formal development background but took pieces of what folks suggested to make this solution. There are very helpful tutorials out there if you have access to Squarespace's Code Injection but for now, I didn't want to upgrade my account to use this.
Step by Step
Go to Pages > create the landing page that you want your folder to direct to > move this page under the Not Linked section
Go to Pages > set up a Folder > click on 'Add Page' > choose 'Link' and enter the slug for your landing page > make sure the Link is the first item in your dropdown
Go to Folder > add the rest of links you want in your dropdown. (This tutorial is clearer when you have this in place.)
Go back to Design > go to Custom CSS
Add this code to move your dropbox higher > adjust the margin-top to line up overlap your folder name
div.header-nav-folder-content {
margin-top: -1.5rem;}
Then add this code to make the first item in your dropdown invisible. This way, it looks like you're clicking the folder name but you're actually clicking the first link in your dropdown.
.header-nav-folder-item:first-of-type a {
opacity: 0;}
Press save and that's it!