Dynamic formula to give active projects followed by inactive projects

[yaswanth92]

Hello everyone, hope you're having an awesome day.

Can you please help me with the dynamic formula that first displays active project names based on the switch (column B) against each project (column A) followed by inactive project names?

Thanks very much in advance. Cheers!

 

[yaswanth92]

Thanks folks! I have got the dynamic formula. Just attaching here for reference.

 

[Peter Bartholomew]

If you care for a shorter formula try

= SORTBY(ProjectName, NOT(Active?))