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