CONTAINS or HAS formula extension

Hi community,

I am looking to extend either a CONTAINS or HAS formula to pick up a dropdown value from one column and assign it a numerical value in a separate column. Can anyone assist in what is the most effective way to do so?

The intention is when any value from the "Suburb Population" column is selected via dropdown it will assign the applicable score in the "Population Ranking" column. Can anyone assist?

=IF(CONTAINS("20K +", [Suburb Population]@row), 10) or

=IF(HAS("20K +", [Suburb Population]@row), 10)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!