Track time an item was open (active)

Steve S
Steve S ✭✭
edited 12/09/19 in Smartsheet Basics

I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ?

I have ideas but have found it makes most sense to run it by one of you first. (Andree)

I welcome your guidance.