rachel1073’s Profile

Community member since May 2019

points
57

4

For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise.

 

For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples,

3

Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the