3

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?

Improve this question

2 Answers 2

Reset to default
2

goto the list settings page and do the calculation from there ;)

column calculation list

In the Validation Settings link on the List Settings page, you can validate one column against another. Here you can see that I’ve set the [Due Date] > [Created].

enter image description here

that should work for you ;)

Improve this answer
3
  • I selected Single line of text for column type and then I pasted the formula into the column validation part , I typed "Düşük" for the default value in Text radiobutton. Is it ok that I select Single line of text? Commented Mar 27, 2013 at 14:57
  • yes single line of text should be fine Commented Mar 27, 2013 at 15:17
  • Still this message occurs.The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column. Commented Mar 27, 2013 at 15:53
0

Try this link http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/844612f1-92ba-49a3-9f89-8013a558c999.

Hope it helps.

Improve this answer
1
  • Please don’t add just a link as answer to a question. If the link is broken, the answer you provided will not be useful for future visitors. Provide an answer of your own and use the link as reference. If needed you can block quote the content from your link. More information is found in our help center, especially How do I write a good answer Commented Jan 9, 2014 at 8:24

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.