JQL request for day 2 of sprint in Structure formula column

[Mikolaj Umiastowski]

Is it possible in a formula column to build a jql that displays something based on the status of a Story on day 2 of sprint. 
I have this, and it works : 

IF JQL {status CHANGED TO 'Deployed' ON '2024/05/21' AND status = 'Deployed'}: "(/)" ELSE IF JQL {status WAS 'In Progress' ON '2024/05/21'}: "(*g)"

But I'd rather not have a fixed date but something like (pseudo-code) : 

status WAS 'In Progress' ON 'day 2 of the sprint'

So that I don't have to change the formula for each new sprint. 

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello  @Mikolaj Umiastowski 

If the issue only has one sprint assigned to it, you can use this formula:

if historical_value(this, "status", date_add(sprint.startdate, 2, "day")) = "In progress": "(*g)"

I hope this helps. If you need further assistance of have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Mikolaj Umiastowski]

Thanks, it helped a lot !
I finally did that : 

with FORMAT_CAPTION(color,offset1) = (
with SPACE(pixels) = """!https://upload.wikimedia.org/wikipedia/commons/5/52/Spacer.gif|width=$pixels!""":
"""{panel:borderStyle=solid|borderColor=white|bgColor=$color}${SPACE(offset1)}{panel}"""
):
IF issuetype = "Story" OR issuetype = "Bug" OR issuetype = "Task" OR issuetype = "Sub-task" OR issuetype = "Epic":
IF DATE_ADD(sprintstartdate, 19, "day") = TRUNCATE_TIME(LatestDone):
"(/)"
ELSE IF historical_value(this, "status", date_add(sprintstartdate, 19, "day")) = "In Progress" AND DATE_ADD(sprintstartdate, 19, "day") < now():
"""{color:#0000FF}${REPEAT("■", 1)}{color}"""

[Mikolaj Umiastowski]

where sprintstartdate is defined in a formula so that I can update it

[Mikolaj Umiastowski]

you can see final result : nt