I am pretty new to this, so apologies if it is a stupid question.
Basically, I want to know if it is possible to create a column that references another column at the level below. Specifically, I have a column called 'Status' at file level with the values, 'Initial', 'In Progress' and 'Completed' I would like to be able to see at the folder level how many of the files are in which status, so I am guessing I need three columns, and then a formula calculating the total of each respective status on the files below. As I am not sure this is clear, a specific example is I have Folder ABC, that contains 100 excel sheets that need to be completed. 20 have status 'Completed', 20 have status In Progress and 60 have status 'Initial' It would be great to see from a quick glance at folder level how work is progressing.
Any ideas gratefully received.