Formula Column to Assign Numeric Values

Thanks so much for your help @Noa-monday.com!

I really appreciate you figuring that out!

I’m getting an error in my formula. Below is the formula I used.

IF({DM}=“Yes”,“5 points”,IF({DM}=“Likely / Influencer”,“4 points”,IF({DM}=“No, but Influencer”,“3 points”,IF({DM}=“Unknown”,“2 points”,IF({DM}=“Unlikely”,“2 points”,IF({DM}=“No”,“1 point”,“3 points”)))))

This is what the column looks like on my board. Does this search by the name of the status, or should I be using the column IDs from the API?