Hi,
I have created structure formula that check
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"""
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.