You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm trying to get conditional formatting working between two numbers so that I can verify if my original estimates reflect back to what should be a Small, Medium, Large story.
For example: If OriginalEstimate is less than 25, return the value, "Small"
ELSE IF OriginalEstimate is greater than 26 and less than 50, return the value, "Medium."
ELSE IF OriginalEstimate is greater than 51 and less than 100, return the value, "Large."
ELSE if greater than 100, return the value, "XL"
I can get the first formula working, but I can't get the latter half working. I've tried
IF OriginalEstimate < 25():
ELSE IF (OriginalEstimate >= 26 && OriginalEstimate <= 50)
and I've tried
IF OriginalEstimate < 25:
ELSE IF OriginalEstimate =>26 and <=50:
Hello @Kiki M
You need to convert the Original Estimate value from a timestamp(which is how it is returned by default) to either days or hours for the formula to work.
if jira_hours(originalestimate) < 24:
if jira_hours(originalestimate) >= 25 and jira_hours(originalestimate) <=50:
I hope this helps. If you need further assistance - please reach out to us directly at our support portal.