Skip to main content

How to convert the weeks into 2-week sprints?

  • July 11, 2023
  • 1 reply
  • 17 views
S
Forum|alt.badge.img

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

    S
    Forum|alt.badge.img+21
    • Sho
    • Inspiring
    • July 11, 2023

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

    ROUND(VALUE(DATETIME_FORMAT({Start Date},"w"))/2)
    Terms & ConditionsAccessibility statement