Hello all. I can't figure out why calculated value on one list(works in other lists) is not working. The fields in sharepoint are set as single line of text. I'm not getting results even in the simplest form i.e. column1 * column2. Any ideas?
Solved! Go to Solution.
I don't see any error. I created another list from scratch have problem with calculated value on this one also. i have four calculated value fields in one form and when one works the other doesn't. Also shows #value on the fields that don't work.
You posted in the SharePoint section but the form provided was an Nintex for O365 form so I have moved the post to the correct category.
The formula in the Proposed Spread Toatal has 1 to many closing brackets ')'
Fix this and see if it resolves your issue.
Not sure why you were not seeing any errors in the browser console. I imported and published the form, opened it and this error appeared and told me what the issue was.