Hi AppSheet Gurus,
I have an app that tracks repair on radios. So when they are received into the system (date) they start aging so that I can see how old a ticket is, and this works great.
(HOUR(Today()-[Date Received]))/24
The issue is that after I change the ticket to closed (repair is done) the aging does not stop, it keeps on aging.
How can I make it that when the status changes to complete TRUe that the aging on that repair stops and shows how long the repair took.
Thank you for any help.
LinkedIn
Twitter
