Share via

Sharepoint List Form - Conditional Formula based on Lookup Field Results

Anonymous
2022-11-21T18:41:41+00:00

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

Microsoft 365 and Office | SharePoint | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2022-11-22T14:58:06+00:00

    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!!!

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-11-22T08:43:24+00:00

    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

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2022-11-22T08:29:18+00:00

    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

    Was this answer helpful?

    0 comments No comments