Help

How to convert the weeks into 2-week sprints?

Topic Labels: Dates & Timezones
641 1
cancel
Showing results for 
Search instead for 
Did you mean: 
shivang
4 - Data Explorer
4 - Data Explorer

I am building an implementation plan for my projects split by a 2-week sprint cycle. While I was able to get Week number from date of delivery, I am stuck trying to covert it into a Sprint number.

1 Reply 1
Sho
11 - Venus
11 - Venus

I don't understand about sprint numbers, but what about dividing the week number by 2?

ROUND(VALUE(DATETIME_FORMAT({Start Date},"w"))/2)