Reply To: Dancing with the Stars

Inner Circle › Ask Smartsheet Guru Crew Anything › Dancing with the Stars › Reply To: Dancing with the Stars

January 28, 2026 at 9:14 pm #8441
Darren
Keymaster

    Michael,
    The star column values are stored as text with the number spelled out vs being a numerical value.
    Therefore, this is the proper formula:

    =IFERROR(IF(Probability@row = “Five”, 0.9, IF(Probability@row = “Four”, 0.7, IF(Probability@row = “Three”, 0.5, IF(Probability@row = “Two”, 0.25, IF(Probability@row = “One”, 0.1, 0))))), 0)

    • This reply was modified 8 months ago by Darren.
    Attachments:
    You must be logged in to view attached files.