I am working to create some generic reporting for a list I have created. The list works based on the values in various fields. The field I am currently stuck on, is the field named: "Status"
Ideally, I need to know how long a specific item remains in that status, or value, from the drop down. I also need to know how many times it changes, and what those changes are, as well as who made them.
My idea is to have a calculated field, that grabs the status, and if it changes, to append that information into the calculated field.
Where would I start in terms of an actual formula for this?