Back story: my workplace has a system where there is a folder with a number as a title 2335, 2187, 2*** etc. Each folder contains a word document, some digital images and sometimes a pdf.
This 2*** folder gets dropped into our 'Location' folder by an external stakeholder. There are almost 40 different 'Location' folders. I have a nice little access document that has buttons that change from green to red when a 'Location' folder receives a folder beginning with a #2.
The 2*** moves into an 'Indexed' folder once some information is placed into an excel spedsheet and given a priority at the end so it will look like 2*** Y, 2*** G, etc
When it has been dealt with it moves to the 'Completed' folder
Work wants a count oh how many folders are in the Location\Indexed folder and preferably a count of how many folders end with Y or G
I can only find scripts that assist with file counts in folders, not folder counts.
Is this even possible?
Edit: fat finger hit send button before I had finished typing.
This 2*** folder gets dropped into our 'Location' folder by an external stakeholder. There are almost 40 different 'Location' folders. I have a nice little access document that has buttons that change from green to red when a 'Location' folder receives a folder beginning with a #2.
The 2*** moves into an 'Indexed' folder once some information is placed into an excel spedsheet and given a priority at the end so it will look like 2*** Y, 2*** G, etc
When it has been dealt with it moves to the 'Completed' folder
Work wants a count oh how many folders are in the Location\Indexed folder and preferably a count of how many folders end with Y or G
I can only find scripts that assist with file counts in folders, not folder counts.
Is this even possible?
Edit: fat finger hit send button before I had finished typing.
Last edited: