I have never managed to reference another sheet let alone a folder alone so I am hoping someone can help me.
Basically, I would like to have a google sheet that can count the number of files within the folder "X" *I have a few different folders that I would like to keep track of so I know how many files are in each of them. Is this possible using google sheets formulas?
*For clarity the folders are also stored on the same google shared drive
I appreciate any help anyone can give me, I have been trying to solve it myself but it doesn't seem to be a popular function.
Thank you.