Copy through column data to sub folders? Sharepoint

Question

Hi, I have created one main folder in my Sharepoint library.
Within this folder I have created 3 subfolders and added a few files also.
I have created a single text column called 'Year' which has appeared throughout all of these folders.
What I would like to do is when I input data into a column attatched to the main folder, I would like all the subfolders and files underneath to also have that data filled in the same columns. To save time as they all have the same information in the columns I want to make.
Thank you in advance for any help and suggestions,
Zac

Answer 1

@Zac Matthews

There're two options for you.

1.Instead of folder, I suggest you use Document Set as first level. In the Document Set, create folder1, folder2 and folder3. And upload some files into Document Set and folders.
(1)Go to Library settings -> In the Content Types section -> Click Document Set -> Add from existing site or list columns -> Add Year column into Document Set content type.
(2)Go to Library settings -> In the Content Types section -> Click Document Set -> In the Document Set settings -> Select Year column in the Shared Columns section.
After that, shared column of the Document Set itself will pass on files inside the document set. But for three folders, you should manually fill in the column value.

2.You could set default value for the Year column. The Year column default value will automatically be filled in for files, but it will not automatically be filled in for folders. For main folder and three sub folders, you should manually fill in the column value.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

in your scenario you may use Document Set instead of folder. Document Set is kind of advanced folder (it's content type inherits Folder CT): i.e. it has all the same features are regular folders plus additional features unique for Document Set. On of these features is called Shared Columns - these columns will be automatically inherited from parent Document Set (once you defined their values there) to files added to this Document Set.