cancel
Showing results for
Did you mean:
See all
##### Top groups
Explore all groups

# Need Help In structure formula for expected epic progress

Tehmina Aslam July 4, 2024

Hi,

I have created structure formula that check

• How many original estimates are within epic example 200
• The epic field have Start date is July 1, 2024, and Due Date = July 30, 2024.
• if means in 30 days 200h to be completed. today is the 4th day from the 30th days
• It should calculate in 30 days almost 26.7 hours has to be completed that means 13% it should be completed in 4 days

here is the formula works but I want to make it red if the due date < 7, yellow if > 7 ...

`WITH totalDuration = dueDate - startDate :WITH daysElapsed = NOW() - startDate :WITH progress = IF totalDuration > 0 AND NOW() <= dueDate : ROUND((daysElapsed / totalDuration) * 100) ELSE : 0 :WITH overdueDays = IF NOW() > dueDate : ROUND((NOW() - dueDate) / (1000 * 60 * 60 * 24)) ELSE : 0 :WITH overdueText = IF NOW() > dueDate : overdueDays CONCAT " days late" ELSE : "" :IF issueType = "Epic" :    IF NOW() > dueDate :        overdueText // Only show overdue text if the due date has passed    ELSE IF totalDuration > 0 :        """\${progress}%"""    ELSE :        """Not Estimated"""`