The National Rivers Consortium is a UK environmental mitigation partnership that supports housing and infrastructure projects in meeting nutrient-neutrality requirements. Working alongside regulators including Natural England and the Environment Agency, they design and deliver wastewater treatment and pollution-reduction schemes that remove excess nitrogen and phosphorus from river catchments. By offsetting the environmental impact of additional wastewater, their work enables planning approvals to proceed while protecting sensitive waterways and habitats.
National Rivers Consortium (NRC) needed a robust, scalable solution to manage nutrient neutrality credits and track mitigation activities across multiple river catchments. The organization required a system that could handle complex credit/developer relationships, provide real-time visibility into phosphorus and nitrogen balances, and support collaboration with external stakeholders. Key requirements included a pooled ledger for tracking intake and mitigation, logic to prevent data errors (such as downstream zones mitigating upstream zones), and the ability to share workspaces securely with external viewers and contractors.
Prodactive designed and implemented a suite of Smartsheet templates tailored to NRC’s needs. This included a mitigation tracker, pooling sheets with zonal logic, and a catchment intake sheet. The solution featured automated dashboards for each catchment, dropdown-driven credit reference management (leveraging Smartsheet’s new functionality for sourcing dropdown options from other sheets), and flexible workspace sharing for both internal and external users. The system was designed to be reusable and easily cloned for new catchments, supporting NRC’s expanding operational footprint.
NRC now benefits from a centralized, transparent system for managing nutrient credits and mitigation activities. The solution has improved data accuracy, streamlined reporting, and enabled secure collaboration with external partners. Users report that the templates are “perfect for what we needed” and appreciate the flexibility to adapt the system as requirements evolve. The engagement has positioned NRC to scale its operations efficiently while maintaining rigorous data controls and auditability.
The templates are perfect for what we needed. We now have a clear, centralized way to manage nutrient credits and track mitigation across all our catchments. The dashboards make it easy to visualize balances, and the system is flexible enough to adapt as our needs change. Sharing workspaces with external partners is straightforward, and the support from Prodactive has been responsive and thorough throughout. We’re very happy with the outcome and confident in our ability to scale this approach.
Thank you for choosing to register to be notified about the upcoming launch of Smarthub:
Please select your Region (note that you need to be logged into Smartsheet to access the registration form)
