Is it possible to define a calculated column such that it's value is taken from another list? example: I have a "emp-data" list with a custom column "emp-value". This column gets updated in various places such as eventhandlers, manually etc. Now for view.reporting purposes I would like to use the above value in another list. I do not want to get into each & every eventhandler and insert code to update the new column. So I thought if I can create a calculated column that will always store the value from another list. If not I was looking if SPD workflow can be used with a condition that whenever "emp-data.emp-value" gets changed, update "emp-summary.emp-value" accordingly. Please suggest.

I don't think you can get a calculated column to work across lists. --Paul Galvin, Computer Generated Solutions (CGS) Microsoft MVP - SharePoint Blogging @ http://feeds.feedburner.com/PaulGalvinsSharePointSpace Twitter @ http://www.twitter.com/pagalvin

No. But you can solve this using event handlers: http://translate.google.com/translate?client=tmpg&hl=es&u=http%3A%2F%2Fsurpoint.blogspot.com%2F2009%2F12%2Fmanejadores-de-eventos-en-sharepoint.html&langpair=es|en.Juan Pablo. surpoint.blogspot.com geeks.ms/blogs/jpussacq Hiciste tu consulta en HispaPoint?

Is it possible through SPD either as workflows or passing values between webparts (i.e on the page there is a webpart that already has a value in one of the columns but I want to use this column value in the other webpart (from a different list))? thanks

As long as your other list is on the same site, use a 'lookup' site column that references the field from the other list.epaloski

Agree with epaloski. Try to use lookup field and if this will be not suficient for you then you can think about event receivers, but in that case be very carefully. I have quite a lot of event receivers in my enviroment and somethimes this is a nightmare to support this. So if you decide to go for then then read, develop and test, test, test, test. and for sure avoid such a beast like "cross-site lookup" Mariusz Gorzoch Blog : http://mariusz.gorzoch.pl Twitter : http://twitter.com/MariuszGorzoch