Check item present in list and return TRUE or FALSE

Jerin_KJ
Jerin_KJ
edited December 2022 in Modeling

Hi Team,

 

I am planning to compare list item from LIST A with  lineitem Assignment code (text format)  in same module. if item present in list A boolean line item in same module will return true else FALSE

List A contain assignment code as follow:

Jerin_KJ_0-1670933564305.png

 

How can I achieve this? Please help.

 

Thanks

JJ

 

Tagged:

Best Answer

  • pyrypeura
    pyrypeura
    edited December 2022 Answer ✓

    Hi,

     

    You can set up formula for your checkup line item to be ISNOTBLANK(FINDITEM(List A, Assignment Code)) . This function check if finditem function finds a match with Assignment Code from List A.

     

    Best regards,

    Pyry

Answers

Categories