Sharepoint List Form - Conditional Formula based on Lookup Field Results

Question

Hi, I've been following the syntax rules from the following link with no results. Have a lookup field called 'OU' (Operating Unit). The additional created column OU:ID. Upon testing, the OU:ID for Customer Service is '28'. I've tried the following but nothing seems to trigger the column with this conditional formula to open.

=if([$OU] == 'Customer Service, 'true', 'false')

=if([$OU] == '28; #Customer Service', 'true', 'false')

=if(Number(substring([$OU],0,indexOf([$OU],';#'))) == 28, 'true', 'false')

Any help would be much appreciated!

Brian

Answer 1

Morning Sean, I appreciate your help. Unfortunately taking off the quotes from the True, False expression did not work. Also, I noticed you had double quotes around Customer Service. It would not save with the double so I put it back to single quotes and it saved fine..

Located this information on the Microsoft Site. Would any of this help. Upon testing, it appears OU:ID = 28 is generated for Customer Service when the recorded is added.

Thanks again!!!

Answer 2

Dear Brian Sparkes1,

You may try this formula: =IF(OU="Customer Service",TRUE,FALSE). We test this formula on our side and it could run normally. ' ' is not needed for true and false.

If there is still the issue, please post back and we will help you.

Thanks for your understanding and cooperation! Have a good day.

Sincerely,

Sean | Microsoft Community Moderator

Answer 3

Dear Brian Sparkes1,

Thanks for posting in Microsoft community. We are glad to help you.

We will have a test on our side based on your requirement and update this thread later.

Thanks for your understanding and cooperation! Have a good day.

Sincerely,

Sean | Microsoft Community Moderator