Jul 11, 2023 12:58 AM
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.
Jul 11, 2023 01:58 AM
I don't understand about sprint numbers, but what about dividing the week number by 2?
ROUND(VALUE(DATETIME_FORMAT({Start Date},"w"))/2)