Hi, Iโm a new App Sheet user and I am trying to hide rows based on whether the answer to the question โPurchase Complete?โ is Yes or No. I am using a table named Leads, โPurchase Complete?โ is the column name, the column type of โPurchase Complete?โ is enum, and the two answer choices are โYesโ and โNoโ. I have read the Slice Row Filter documentation and am still lost at the moment. Any advice would be greatly appreciated!
Solved! Go to Solution.
The slice configuration looks fine. In order for it to effectively hide rows from the user, the views that display data to the user must be based on this slice not on the Potential Sales table itself.
If you are wanting to create a slice called PurchaseTodo that hides rows where โPurchase Complete?โ is Yes, you can use [Purchase Complete?]=โNoโ as the slice filter.
@Bellave_Jayaram - thanks for your response. Unfortunately, that does not seem to work for me. Here is a screenshot of my configuration. Do you notice anything that looks off?
The slice configuration looks fine. In order for it to effectively hide rows from the user, the views that display data to the user must be based on this slice not on the Potential Sales table itself.
@Steve, that is what I was missing - thanks for the help!
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |