Formula Help with Symbols Column
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
Comments
-
=IF(ISBLANK([Time to Comp]@row), "Empty", IF([Time To Comp]@row = "5", "One", IF(OR([Time To Comp]@row = "10", [Time To Comp]@row = "15"), "Two", IF([Time To Comp]@row = "30", "Three", IF([Time To Comp]@row = "45", "Four", IF(OR([Time To Comp]@row = "1hr", [Time To Comp]@row = "2hr", [Time To Comp]@row = "4hr", [Time To Comp]@row = "8hr"), "Five"))))))
Give this a try.
-
It worked perfectly! I never saw the use of @row before, I thought I would have to put in the row number after I pasted it in but it works fine without it.
Thank you so so much!!!!
-
Happy to help. I use @row a lot. It makes copy/pasting so much easier.
-
Nice solution there Paul.
Thanks for sharing!
RichardR
SMarter Business processes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!