Multi-Criteria Project Filter Dashboard

Global Project Management Inc. needs an interactive dashboard to filter active projects by multiple criteria (department, budget tier, risk level) with dynamic sorting.
Dataset Structure:

Multi-Criteria Project Filter Dashboard

Function Focus: FILTER, SORTBY

Scenario:

Global Project Management Inc. needs an interactive dashboard to filter active projects by multiple criteria (department, budget tier, risk level) with dynamic sorting.
Dataset Structure:
• Project_ID, Project_Name, Department, Budget ($), Risk_Level (Low/Med/High), Status, Start_Date, Completion_%
• 50+ active projects across 5 departments


Tasks:
1.Create a FILTER() formula that accepts multiple criteria (Department = "IT" AND Risk = "High" AND Budget > $50,000)
2.Implement SORTBY() to arrange results by Completion_% (descending) then Budget (ascending)
3.Build interactive dropdowns that update the filtered view dynamically
4.Handle #CALC! errors gracefully when no matches exist

Expected Output:
Interactive dashboard showing only matching projects, auto-sorted by priority metrics.
Evaluation Criteria:Multi-criteria FILTER logic, nested SORTBY implementation, error handling