Need Help In structure formula for expected epic progress

[Tehmina Aslam]

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"""