How do I get a filter that shows all the items that have not been completed in a sprint?

[Evalaji Jones]

need a filter for the deferrals. 

[Walter Buggenhout · Accepted solution]

Hi @Evalaji Jones,

If you know the end date of your sprint and the columns that are mapped to the rightmost column of your scrum board, that is not so hard to do.

Suppose your sprint is called Sprint Koala, the sprint was completed on December 23rd, 2022 and the rightmost column of your board is mapped to the Done status, the following should work:

Sprint = "Sprint Koala" AND status WAS NOT Done ON 2022-12-23

Hope this helps!

[Evalaji Jones]

thank you ! 

[filzah hanis]

are we able to automate the date such that it updates at the end of every sprint?