Covert Size to value

[Zephyrus Mckinnon]

Hello!
I have not worked with JQL very much. I would like a little help doing a formula.
I would love any help! Thank you so much!

[David Niro · Accepted solution]

Hello @Zephyrus Mckinnon ,

David from ALM Works here.

Are you using a Select List (single choice) field for your t-shirt size?

If you are, you will want to add a Formula column to your structure.

The formula will look like this:

IF(T_Shirt_Size = "XS";1; 
T_Shirt_Size = "S";2; 
T_Shirt_Size = "M";7; 
T_Shirt_Size = "L";15; 
T_Shirt_Size = "XL";30)

T_Shirt_Size will be a variable in your formula and you will want to make sure it maps to the field you use for entering your t-shirt size.

We may need to make some adjustments based on the type of field you are using as well as what the specific value options are.  This should give you an idea of what needs to be done though.

Please let me know if it works for you, or if you have any additional questions!

Best,
David

[Dave Rosenlund _Trundl_]

Hi, @Zephyrus Mckinnon. Welcome to the community!

There are some key words in your post that strongly suggest you are using Structure  — namely Formula and Effectors.

However, you (or it could be someone else) added a couple of cloud tags to your post.  

Can you please confirm you are using Structure, and are on Jira Cloud?  That way you are more likely to get the right help. :) 

-dave

[Zephyrus Mckinnon]

I am using Structure