jeudi 30 mai 2019

SharePoint 2010 List, Calculated Column, If-statement modification not working

I had a formula in a calculated column that worked just fine. I tried to revised the formula, reusing part of what worked before (in bold), but it keeps taking me to syntax error screen. The new formula is much simpler.

I've looked online, but can't find the issue.

Old formula:
=IF(AND(LEFT([EVENT TYPE],8)<>"Mtng (PM",LEFT([EVENT TYPE],8)<>"Mtng (eP",LEFT([EVENT TYPE],8)<>"Mtng (DS",LEFT([EVENT TYPE],8)<>"Mtng (#D"),"N/A for this row", IF(OR([(DC1) EDS?]="",[(DC2) Part Info]="",[(DC3) Part Innov]="",[(DC4) Other]=""),"Fill DC columns (1-4)",IF(OR(LEFT([(DC1) EDS?],1)<>"4",LEFT([(DC2) Part Info],1)<>"4",LEFT([(DC3) Part Innov],1)<>"4",LEFT([(DC4) Other],1)<>"4"),"Yes","No")))

New Formula (that throws error):
=IF(AND(LEFT([EVENT TYPE],8)<>"Mtng (PM",LEFT([EVENT TYPE],8)<>"Mtng (eP",LEFT([EVENT TYPE],8)<>"Mtng (DS",LEFT([EVENT TYPE],8)<>"Mtng (#D"), "N/A for this row", [Add to Data Collection Calendar?])

The syntax and condition in the revised formula (in bold) is straight out of the old formula. Instead of adding other If statements, I just want the formula to enter the contents of "Add to" column if condition is false.

The "Add to..." column is a choice column.
The "EVENT TYPE" column referred in condition is also a choice column. (This condition evaluates correctly in the old, longer formula).

I've tried to set the calculated column to simply "=[Add to Data Collection Calendar?]" to check if there's an issue with "Add to..." column, but that formula works and gets me the contents of "Add to..." column.

It's got to be something simple that I can't seem to find.

Aucun commentaire:

Enregistrer un commentaire