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")

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