Status Change timestamps via API?

Hi all - I’m wondering there’s any way to access a timestamp whenever a status changed so we can calculate days-in-status?

For example, we have a status of “Registration” and “Discovery” and we want to measure the amount of time that elapsed between the the status of “Registration” was first applied and when it was changed to “Discovery” and put that in a report.

Is this possible?

Yes you can access it with the “additional_info” property.
it returns a JSON and if you parse it you’ll get a “changed_at” value.

{
boards(ids: [354865738]) {
id
name
items {
id
name
column_values {
id
additional_info
}
}
}
}

@SADA-Jon,

Assuming that you might not want to have to use the API to access the change date/time info, you might consider creating a date column for the date you want to capture then use this automation to update the value:
image