Is there a keyboard shortcut for filling in the 1 - 5 Star Rating in a Symbol Column?

jessica@phoenix

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.

Ramzi K

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:

1. Create a value column for the user to enter a number from 1-5 (in this example it's called Value)
2. 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 K

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:

1. Create a value column for the user to enter a number from 1-5 (in this example it's called Value)
2. 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

jessica@phoenix

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