Formula Help with Symbols Column

Lisa
Lisa ✭✭
edited 12/09/19 in Formulas and Functions

Hey, can anyone help me with this? I have a column called Time to Comp which is a dropdown with the following -

5

10

15

30

45

1hr

2hr

4hr

8hr

I have another column called TimeCompSym with the 1 - 5 stars. I would like this column to populate the stars based on the value in the Time to Comp column.

1 star = 5

2 stars = 10 or 15

3 stars = 30

4 stars = 45

5 stars = 1hr or 2hr or 4hr or 8hr

I am not great at nested if statements so if help would be greatly appreciated, thank you!!!!

Lisa

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!