Smartsheet Auto-calculation & Dashboard Creation

I'm looking for a Smartsheet expert who can help create a comprehensive resource allocation sheet that auto-calculates and generates an easy-to-read dashboard. As a clinical researcher, we are looking for a Smartsheet expert to help us manage our clinical trials. From managing budgets, resource allocation, budget reconciliation, to coordinating activities across multiple programs within our portfolio. We need to build a Clinical Project, Program, and Portfolio Management solution within Smartsheet! Things we must have: 01. Timelines & Milestones With smartsheet we need visibility for a single source of truth for trial timelines, milestones, and budgets. This can help you ensure that your trial stays on track and within budget. 02. RAID Tracking Mitigate risks and issues: So we can quickly identify and mitigate risks and issues. This can help you avoid costly delays and ensure that your trial runs smoothly. 03. Accurate Reporting generates accurate and timely reports for internal and external stakeholders. This will help keep everyone informed about the progress of our trials and ensure everyone is reading from the same page. Key Responsibilities: - Track budget allocations and expenditures. - Monitor and display resource utilization, project progress, and cost tracking on the dashboard. - Include metrics for 30-day, 60-day, and 90-day tasks, as well as the critical path and combined trajectory of the entire portfolio. Ideal Skills: - Deep understanding of Smartsheet features and capabilities. - Ability to visualize complex data in an accessible way. - Experience with long-term project tracking (one to three years). Please provide examples of similar projects (MUST BE USING SMARTSHEET) you've completed and how you approached them.