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?
