I have a column named "Risk" and the condition of the values is here:
Düşük: Risk <= 4
Orta: 4 < Risk <8
Yuksek: 8 <= Risk
Risk value is the sum of 2 column values.
Risk value: [Column1] + [Column2]
The default value is calculated value:
=IF( ([Etki]+[Olasılık])<=4, "Düşük", IF( ([Etki]+[Olasılık])>=8, "Yüksek", "Orta") )
The type of "Risk" is Single line of text a but it doesn't work. It keeps saying "The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column. " What am I doing wrong?