Hey everyone! this is my first post here, hope that’s the right place, and thanks in advance :slightly_smiling_face:
I have a table that is synced to a Google Drive folder, adding new records each time files are added.
I want to write a formula that numbers the files in each folder in a new column, so for example if I have 5 records of a folder named “test” I’ll have a column counting 1,2,3,4,5 in the new records created. when a new folder is added, I want the count to begin from 1 again.
Is that possible? Again - thank you so much, everyone!