Smartsheet Landfill Monitoring Setup

I’m looking for a Smartsheet power-user who can turn my existing data into a true operation command center. The goal is to see, at a glance, how every landfill well is performing, when each was last inspected, and whether our gas readings are slipping below safe limits.

Here’s what I need:

• Operation command center dashboard that clearly shows
– Real-time gas composition updates
– Maintenance status overview for every well
– Alerts and notifications tied to preset thresholds

• Automated alerts that fire when gas drops below the limits I’ll provide or when any well goes more than seven days without a reading.

• A daily maintenance entry form built with text input fields, dropdown selections, and checkboxes so field techs can log data quickly on mobile.

You’ll set up the underlying sheets, formulas, cross-sheet references, and workflows so all numbers feed the dashboard live. After a brief walk-through to confirm everything works, we’ll consider the job complete.