Help with setting a formula

Hello,

I have a table and want to create a new column to organize the view of data according to this criteria.

Priority one: Year, (formatted in numbers, ex: 2001) Column D (lowest to highest);

Priority two: Rewatch, (formatted in text, Yes and No) Column E (Yes first, No second);

Priority three: Rating, (formatted in numbers, 1 to 5) Column G (lowest to highest)

I've tried the following formula:

=TEXT(D2, "0000") & IF(E2="Yes", "0", "1") & TEXT(G2, "00")

Problem: It doesn't factor the Yes and No

I don't know how to go about this, I'm not an excel expert.

Can someone help please?