Saved Search for Matrix Item

I’m trying to create a saved search to lookup Matrix Parent Items who have an empty custom id, but the child item has a value for the customid.

 

Would love insight to how to best do this or if I need to reference a excel vlookup.

Rookie Asked on August 4, 2022 in Saved Searches.
Add Comment
1 Answer(s)

Hi Rlp,

–>Go to Lists > Search > Saved Searches > New
–>Click on the Results tab > open Columns, add the Formula Text Field:

Use Formula  “CASE WHEN {parent} is not null then ‘Yes’ else ‘No’ END”**

You can give the Label you want or simply “Matrix Child ”
–Click Save & Run.

You will see in search result those items which are Matrix Child will come as Yes and other will come as No.

Beginner Answered on February 7, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor