This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to make a slice using CONTAINS. The column I am trying to use is a Ref column, so the actual text is not in the sheet, but the ID of the parent sheet. How do you use CONTAIN with a Ref column of the child sheet?