Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
add comment

2 Answers

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 ;)

share|improve this answer
    
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? –  e.ozmen Mar 27 '13 at 14:57
    
yes single line of text should be fine –  ali Sharepoint Mar 27 '13 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. –  e.ozmen Mar 27 '13 at 15:53
add comment

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

Hope it helps.

share|improve this answer
1  
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. –  Mike Mar 27 '13 at 14:25
    
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 –  Benny Skogberg Jan 9 at 8:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.