Do you know a way to track or show the changes history of certain field in the same sheet?
Let´s take the sales template. Leads sheet.
We have a field to set the lead status.
What I want to do is track days then the user changes this status and show it to the current user. This way the user will know when was the first time he worked on the same record (based on the field “status”).
We need to track how many days passed from the date the field start with the default value (lets say “new”) to when the field changed to the last value (i.e. “qualified”).
How about including another read only field (in the same sheet) to show a list of “last modified status” or “last modified value”?