I’ve got a Zap connecting a Hubspot Form to Google Sheets - I want the data submitted in the form to populate the Sheet. All the fields are working other than the date of birth input and the Gender dropdown.

Note, I can’t figure out the date formatting issue for DOB so I am using a formula suggested elsewhere in the community.

The question to the community is how I can solve for the Gender dropdown populating in Sheets. This is a 2 option Dropdown for Gender (either Male of Female)

Thanks in advance!