HELP!! SharePoint List Conditional Formula!

%3CLINGO-SUB%20id%3D%22lingo-sub-2749542%22%20slang%3D%22en-US%22%3EHELP!!%20SharePoint%20List%20Conditional%20Formula!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749542%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20branch%20off%20entries%20on%20my%20SP%20list%20depending%20on%20what%20the%20user%20selects.%20I%20have%20accomplished%20this%20before%20and%20it%20works%20great.%20The%20issue%20with%20this%20new%20set%20up%20is%20I%20need%20a%20specific%20field%20(I.E%20New%20Department)%20to%20show%20if%20the%20user%20selects%20%22Team%20change%22%20or%20if%20they%20select%20%22Department%20change%22.%20In%20other%20world%20the%20its%20and%20IF%20xxx%20and%20or%20xxx.%20I%20set%20the%20formula%20as%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3Dif(%5B%24REASON_x0020_FOR_x0020_REQUEST%5D%3D%3D'Team_x0020_change'%2C%20'true'%2C%20if(%5B%24REASON_x0020_FOR_x0020_REQUEST%5D%3D%3D%20'Department_x0020_change'%2C%20'true'%2C%20'false'))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20system%20accepts%20the%20formula%20but%20IT%20ISN%22T%20WORKING%20HELP!!!%20The%20field%20doesnt%20appear%20when%20I%20select%20either%20trigger%20(%26nbsp%3B%22Team%20change%22%20or%26nbsp%3B%20%22Department%20change%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2749542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

 

I would like to branch off entries on my SP list depending on what the user selects. I have accomplished this before and it works great. The issue with this new set up is I need a specific field (I.E New Department) to show if the user selects "Team change" or if they select "Department change". In other world the its and IF xxx and or xxx. I set the formula as:

 

=if([$REASON_x0020_FOR_x0020_REQUEST]=='Team_x0020_change', 'true', if([$REASON_x0020_FOR_x0020_REQUEST]== 'Department_x0020_change', 'true', 'false'))

 

The system accepts the formula but IT ISN"T WORKING HELP!!! The field doesnt appear when I select either trigger ( "Team change" or  "Department change")

1 Reply
You have posted on the Microsoft Learn community board which is all about exams, certification and training.
You might get a better response on the Microsoft SharePoint community https://gorovian.000webhostapp.com/?exam=t5/sharepoint/ct-p/SharePoint
www.000webhost.com