Display only parents in card view
i have parent rows with children and i have used a formula to identify the parents. i want to use a filter so that when viewing Card View i only see parent rows and NO children. i cant figure out how to do it. even when i filter using my "is parent" (=1) column i get more than that
Best Answer
-
Hi @Billymacdo, I just created a sheet and got this to work.
I created an "IsParent" checkbox column, with a column formula, an this is the formula that I used.
=COUNT(CHILDREN()) > 0
Then in the Card View, I created a filter that checks if "IsParent" "is checked".
This is the result:
If doing something similar doesn't work for you, then can you post some screenshots so that I can help dig in further?
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
Answers
-
Hi @Billymacdo, I just created a sheet and got this to work.
I created an "IsParent" checkbox column, with a column formula, an this is the formula that I used.
=COUNT(CHILDREN()) > 0
Then in the Card View, I created a filter that checks if "IsParent" "is checked".
This is the result:
If doing something similar doesn't work for you, then can you post some screenshots so that I can help dig in further?
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
-
this did the trick. it also turned out that i had a bunch of dirty orphan data that i didn't see which ultimately was tricking me
-
Glad it worked!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
