How to count Child Items based a dropdown list of criteria
I want to be able to summarize how many child rows are open in the Purchasing Status column. This is a dropdown list column. In this example I want to count what is Not Ordered and Ordered. Ideally I would like to do that in the Parent row for Detail "000", but as a dropdown column I suspect I'll need to enter the formula in another column, or perhaps even a linked sheet that pulls in data from the parent row for all jobs. I want to do this with multiple columns. I could use some direction on the best way to accomplish this and also the formula to count using that kind of criteria. I know how to do this in Excel, but struggling in Smartsheet.
Help Article Resources
Check out the Formula Handbook template!