Populating a Value in a Column Based on a Dropdown value in another

Trying to get this formula to work. Taking a value (4 different values) that is a word "1 Year" and create a days value column so it can be used in a date calculation column. In this case the value in the DaysValue column would be 365.

=IF([SelfExclusionLength]@row = "1 Year", "365", [Days Value]@row)

I get a circular reference each time. Is it because there are multiple choices in the self exclusion dropdown list. Any simple way to attach a numeric value to a dropdown list value programmatically? We can't use days in the dropdown which would solve the problem.

Any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!