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