Re: Sharepoint Calculated Fields Using Published IP Fields

Hilary Stoupa — Thu, 15 Nov 2012 16:21:01 GMT

Any chance there is a difference in the column names?

Re: Sharepoint Calculated Fields Using Published IP Fields

Jen B — Thu, 15 Nov 2012 16:06:41 GMT

Anyone have any thoughts? I haven't been able to resolve the issue.

Thanks
Jen

Sharepoint Calculated Fields Using Published IP Fields

Jen B — Thu, 01 Nov 2012 17:37:02 GMT

Good afternoon,
I've run into an issue and am hoping someone has run into it before...and has a solution :). Here's the set up:

I have two identical IP 2010 Filler forms that are published to two different 2007 sharepoint libraries (this was done because the form has over 600 fields and I ran into publishing issues using just one library)...we'll call them Library A and B. Here's how the process works...
Requestor opens new form from Library A. On submit, form details are submitted to both Library A and B. Teams grab and work submissions from Library B. On Save, new data is submitted to both libraries.

All works just dandy. I now wanted to start adding some visuals for our team and requestors. So, I built out calculated fields to visually show the choice made in the request condition (On Track, Caution, At Risk) field that comes from infopath form. In Library A, it all works terrifically. In Library B, the same formulas are giving me sharepoint errors saying "values do not fall within the expected range".

Since the formula works in one library and not the other, I'm presuming it isn't the formula. My only thought is that possibly the fields in Library B act differently because the data comes from List A form... but I'm just grasping at straws.

Has anyone run into this or have thoughts on why MOSS calculated fields would work in one Library and not the other?

Thanks!

Jen

SharePoint Integration

Re: Sharepoint Calculated Fields Using Published IP Fields

Re: Sharepoint Calculated Fields Using Published IP Fields

Sharepoint Calculated Fields Using Published IP Fields