Is there a keyboard shortcut for filling in the 1 - 5 Star Rating in a Symbol Column?
I feel like i should know how to do this but I can't figure it out right now. I know how to do it with different symbols columns. (Example, If I want to fill in a bunch of Checkboxes, I'd use "1" for Checked & "0" for Unchecked.) ...
I want to add a column for each Project Manager that allows them to rate 500+ Subcontractors using the 1 - 5 Star Rating. If I can have the text value associated with these, it'll make things much easier and quicker for those filling it out.
Best Answer
-
If I understand you correctly, you want the user to enter a number and get a symbol to match. If so, you can do this:
- Create a value column for the user to enter a number from 1-5 (in this example it's called Value)
- Put this formula in your Rating column: =IF(Value@row = 1, "One", IF(Value@row = 2, "Two", IF(Value@row = 3, "Three", IF(Value@row = 4, "Four", IF(Value@row = 5, "Five", "")))))
I hope this works for you.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
If I understand you correctly, you want the user to enter a number and get a symbol to match. If so, you can do this:
- Create a value column for the user to enter a number from 1-5 (in this example it's called Value)
- Put this formula in your Rating column: =IF(Value@row = 1, "One", IF(Value@row = 2, "Two", IF(Value@row = 3, "Three", IF(Value@row = 4, "Four", IF(Value@row = 5, "Five", "")))))
I hope this works for you.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thank you, this was the article i was looking for too & couldnt find before. Thanks!
https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column
