Sharepoint list code syntax check

%3CLINGO-SUB%20id%3D%22lingo-sub-3503320%22%20slang%3D%22en-US%22%3ESharepoint%20list%20code%20syntax%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3503320%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EI%20want%20to%20create%20a%20Status%20field%20which%20is%20going%20to%20be%20a%20governed%20by%20a%20formulla.%3C%2FP%3E%3CP%3EThe%20following%20are%20the%20statuses%20to%20be%20printed.%3CBR%20%2F%3E1.%20To%20be%20launched%3CBR%20%2F%3E2.%20Ongoing%3CBR%20%2F%3E3.%20Under%20Extraction%26nbsp%3B%3CBR%20%2F%3E4.%20Pending%20Signoff%3CBR%20%2F%3E5.%20Site%20Release%20Pending%3CBR%20%2F%3E6.%20Released%20to%20Site%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20status%20bar%20should%20automatically%20updated%20according%20to%20the%20following%20formulla%3B%3CBR%20%2F%3EIf%20Term%20Sheet%20Status%20%3D%20Yes%20%26amp%3B%26amp%3B%20Launch%20Date%20Status%20%3D%20No%2C%20print%20-%20To%20be%20launched.%3CBR%20%2F%3EIf%20Launch%20Status%20%3D%20Yes%20%26amp%3B%26amp%3B%20Layout%20Signoff%20Status%20%3D%20No%2C%20print%20-%20Ongoing%3C%2FP%3E%3CP%3EIf%20Layout%20Signoff%20Status%20%3D%20Yes%20%26amp%3B%26amp%3B%20Customer%20Release%20Status%20%3D%20No%2C%20print%20-%20Under%20Extraction%3C%2FP%3E%3CP%3EIf%20Customer%20Release%20Status%20%3D%20Yes%20%26amp%3B%26amp%3B%20Customer%20Signoff%20Status%20%3D%20No%2C%20print%20-%20Pending%20Signoff%3CBR%20%2F%3EIf%20Customer%20Signoff%20Status%20%3D%20Yes%20%26amp%3B%26amp%3B%20Site%20Release%20Status%20%3D%20No%2C%20print%20-%20Site%20Release%20Pending%3C%2FP%3E%3CP%3EIf%20Site%20Release%20Status%20%3D%20Yes%2C%20print%20-%20Released%20to%20Site%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20is%20the%20code%20that%20I%20wrote%20for%20the%20same.%20But%20its%20showing%20SYNTAX%20ERROR.%20If%20someone%20can%20help%20me%20out%20with%20this.%3CBR%20%2F%3E%3CBR%20%2F%3EIF(AND(%5BTerm%20Sheet%20Signed%20Status%5D%3D%22Yes%22%2C%5BLaunch%20Status%5D%3D%22NO%22%2C%22TO%20BE%20LAUNCHED%22%2C%3CBR%20%2F%3EIF(AND(%5BLaunch%20Status%5D%3D%22YES%22%2C%5BLayout%20Signoff%20Status%5D%3D%22NO%22%2C%22ONGOING%22%2C%3CBR%20%2F%3EIF(AND(%5BLayout%20Signoff%20Status%5D%3D%22YES%22%2C%5BCustomer%20Release%20Status%5D%3D%22NO%22%2C%22UNDER%20EXTRACTION%22%2C%3CBR%20%2F%3EIF(AND(%5BCustomer%20Release%20Status%5D%3D%22YES%22%2C%5BCustomer%20Signoff%20Status%5D%3D%22NO%22%2C%22PENDING%20SIGNOFF%22%2C%3CBR%20%2F%3EIF(AND(%5BCustomer%20Signoff%20Status%5D%3D%22YES%22%2C%5BSite%20Release-AR%20Status%5D%3D%22NO%22%2C%22SITE%20RELEASE%20PENDING%22%2C%3CBR%20%2F%3EIF(%5BSite%20Release-AR%20Status%5D%3D%22YES%22%2C%22RELEASED%20TO%20SITE%22%2C%3CBR%20%2F%3E)))))%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3503320%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3503643%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20list%20code%20syntax%20check%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3503643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1423345%22%20target%3D%22_blank%22%3E%40Intern_cPMO%3C%2FA%3E%26nbsp%3Bthe%20first%20thing%20I%20noticed%20was%20that%20you%20have%20no%20%3CEM%3Eelse%3C%2FEM%3E%20on%20the%20last%20if%20statement%3C%2FP%3E%3CP%3E%3CSPAN%3EIF(%5BSite%20Release-AR%20Status%5D%3D%22YES%22%2C%22RELEASED%20TO%20SITE%22%2C%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)))))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20an%20else%20clause%20where%20I've%20put%20%3CFONT%20color%3D%22%23DF0000%22%3E%22%3F%3F%3F%22%3C%2FFONT%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIF(%5BSite%20Release-AR%20Status%5D%3D%22YES%22%2C%22RELEASED%20TO%20SITE%22%2C%20%3CFONT%20color%3D%22%23DF0000%22%3E%22%3F%3F%3F%22%3C%2FFONT%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E)))))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,
I want to create a Status field which is going to be a governed by a formulla.

The following are the statuses to be printed.
1. To be launched
2. Ongoing
3. Under Extraction 
4. Pending Signoff
5. Site Release Pending
6. Released to Site

This status bar should automatically updated according to the following formulla;
If Term Sheet Status = Yes && Launch Date Status = No, print - To be launched.
If Launch Status = Yes && Layout Signoff Status = No, print - Ongoing

If Layout Signoff Status = Yes && Customer Release Status = No, print - Under Extraction

If Customer Release Status = Yes && Customer Signoff Status = No, print - Pending Signoff
If Customer Signoff Status = Yes && Site Release Status = No, print - Site Release Pending

If Site Release Status = Yes, print - Released to Site

 

 

The following is the code that I wrote for the same. But its showing SYNTAX ERROR. If someone can help me out with this.

IF(AND([Term Sheet Signed Status]="Yes",[Launch Status]="NO","TO BE LAUNCHED",
IF(AND([Launch Status]="YES",[Layout Signoff Status]="NO","ONGOING",
IF(AND([Layout Signoff Status]="YES",[Customer Release Status]="NO","UNDER EXTRACTION",
IF(AND([Customer Release Status]="YES",[Customer Signoff Status]="NO","PENDING SIGNOFF",
IF(AND([Customer Signoff Status]="YES",[Site Release-AR Status]="NO","SITE RELEASE PENDING",
IF([Site Release-AR Status]="YES","RELEASED TO SITE",
)))))


 

 

 

1 Reply

@Intern_cPMO the first thing I noticed was that you have no else on the last if statement

IF([Site Release-AR Status]="YES","RELEASED TO SITE", 
)))))

 

You need an else clause where I've put "???"

IF([Site Release-AR Status]="YES","RELEASED TO SITE", "???"
)))))

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)