Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have a bookmarked filter that is active. The goal is to create a dynamic label that will react if the bookmarked filter is either active or deactivated. Is it possible to create a dynamic label in a master item if I have a bookmarked filter that is currently active but will react when deactivated? Below is an example.
Active Bookmarked Filter Ex: Filter = Pineapple Pizza? > Yes
Active Bookmarked Filter Ex: Label = "Yes, I love Pineapple Pizza!"
Deactivated Bookmarked Filter Ex: Filter = Pineapple Pizza? > No
Deactivated Bookmarked Filter Ex: Label = "No, are you crazy? You never put Pineapple on Pizza!"
Is this possible for master item labels? How would you create a syntax that would make this work?
I was overthinking this and quickly found a solution:
= IF( [Pineapple Pizza?] = 'Y', 'Yes, I love Pineapple Pizza!', 'No, are you crazy? You never put Pineapple on Pizza!' )
I was overthinking this and quickly found a solution:
= IF( [Pineapple Pizza?] = 'Y', 'Yes, I love Pineapple Pizza!', 'No, are you crazy? You never put Pineapple on Pizza!' )