how can I get the week number from an issue's End Date field?

Doug Robinson July 8, 2021

I would like to create a board view where the swimlanes are (ascending) "end week" of the year. It would be a clearer way for mgmt to see what is being delivered when.. more so than just the ranked tickets on the Kanban board. 

I assume I create a custom 'end week' field and, update it thru Automation when the End Date field changes...?  but I can't figure out how to get that to work. 

1 answer

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 8, 2021

Hi @Doug Robinson 

The smart value to return the week number for the current date/time:

{{now.format("w")}}


Best regards,
Bill

Doug Robinson July 8, 2021

thank you for your fast reply.. that helped! 

Like Bill Sheboy likes this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2021

Doug, I am glad that helped you.  Please consider marking this question as "answered" in order to help others in the community find solutions faster.  Thanks!

Suggest an answer

Log in or Sign up to answer