Hi all, just started using smartsheets, I was wondering how can I capture and present ONLY the last

Monardo

Hi all, just started using smartsheets, I was wondering how can I capture and present ONLY the last 24 hours events of breakdowns, i.e each machine how many stops, how long each stop and total stoppage time in the plant to show it in the daily morning meeting. Many thanks

Monardo

KPH

Hi

Could you create a filter on the sheet (or on a report created from the sheet)? Depending on how accurate you want the "ONLY the last 24 hours" to be you could set up a simple filter for downtime started in the last 1 days or downtime end is in the future, or a more complicated filter based on a helper column to include the times.