How to change star symbol to number equivalent?

wliddick

I want to change the number of stars in a symbol column to a number equivalent in a column next to it, but do not seem to have the formula correct. It looks like it is a valid formula, but all I receive back is a blank. Here's the formula:

Any thoughts on how to make this work would be appreciated.

Thanks,

Bill

Rochelle from Agilize

Hi Bill,

The star values are actually text, not numbers. So, your formula would look something like this: =IF([ Your Star Column]@row="Three", "Three")

Rochelle from Agilize

Hi Bill,

The star values are actually text, not numbers. So, your formula would look something like this: =IF([ Your Star Column]@row="Three", "Three")

wliddick

Hi Rochelle,

Perfect! That took care of the issue.

Thank you,

Bill

Rochelle from Agilize

Absolutely! 😀