locked
Deleted RRS feed

Answers

  • Hello dineshaachen,

    You could create two hidden columns and one event receiver which save the value of the calculated columns in these new columns.

    Thus, you could create your calculated column properly referencing it to these new columns.

    Hope this helps

    • Marked as answer by Patrick_Liang Monday, January 19, 2015 7:11 AM
    Thursday, January 15, 2015 9:54 AM
  • This can't be done using calculated columns because calculated columns can only be used for columns on the same list.

    Using SharePoint Designer Workflows you can just use Create List Item and Update List Item actions so that whenever a user adds a value the item will be added in another list's column which contains the previous amounts already.

    http://stackoverflow.com/questions/16295567/how-to-create-calculated-column-with-data-from-another-list

    https://social.msdn.microsoft.com/forums/sharepoint/en-US/01989169-eac7-4f28-809d-6e5af400fb03/lookup-column-to-calculated-field-showing-string-at-beginning


    Please 'propose as answer' if it helped you, also 'vote helpful' if you like this reply.

    • Marked as answer by Patrick_Liang Monday, January 19, 2015 7:11 AM
    Thursday, January 15, 2015 4:27 PM

All replies

  • Hello dineshaachen,

    You could create two hidden columns and one event receiver which save the value of the calculated columns in these new columns.

    Thus, you could create your calculated column properly referencing it to these new columns.

    Hope this helps

    • Marked as answer by Patrick_Liang Monday, January 19, 2015 7:11 AM
    Thursday, January 15, 2015 9:54 AM
  • This can't be done using calculated columns because calculated columns can only be used for columns on the same list.

    Using SharePoint Designer Workflows you can just use Create List Item and Update List Item actions so that whenever a user adds a value the item will be added in another list's column which contains the previous amounts already.

    http://stackoverflow.com/questions/16295567/how-to-create-calculated-column-with-data-from-another-list

    https://social.msdn.microsoft.com/forums/sharepoint/en-US/01989169-eac7-4f28-809d-6e5af400fb03/lookup-column-to-calculated-field-showing-string-at-beginning


    Please 'propose as answer' if it helped you, also 'vote helpful' if you like this reply.

    • Marked as answer by Patrick_Liang Monday, January 19, 2015 7:11 AM
    Thursday, January 15, 2015 4:27 PM
  • you cant use calucalted columns for two different lists

    try enrique answer

    Friday, January 16, 2015 3:47 AM