I have built a form that also has a SharePoint form Validation formula. This validation formula works fine when I:
- Create a new form
- Update a new form
- Run a list workflow (Nintex) with update field
all have no issues. The problem comes up when I created a site workflow and try to update a field. This will give me
The workflow could not update the item, possibly because one or more columns for the item require a different type of information
Here is my validation formula
=IF(AND(CM="Yes",[CM Status]="No CM"),FALSE,IF(AND([Date Completed]<>"",[Work Start Date]=""),FALSE,TRUE))
The validation just checks two parameters:
- If the field CM is set to yes and makes sure that the CM Status is not set to "No CM"
- If the Date completed is filled in, then make sure the Work Start Date is also filled in
The Site Workflow is trying to updates something that is not even related to the formula, which is to update the item Due Date.
If I take the validation away, the workflow runs without any issues, put that validation formula back, it throws the message. It's also worth mentioning that with the validation formula in place, regardless of what field I try to update, it throws the same error message.
What am I missing?
Thanks in advance for the help.