Description
I have created a spreadsheet to demonstrate: https://docs.google.com/spreadsheets/d/1aYb1mycYTwy67j2E9KNbJ7YVeAITQUO-hjWmm6iBoeA/edit?usp=sharing
This is how I reproduced the situation:
A:)
The sheet 'validation' I have prepared in a column (ColC) with each function preceded by a tick '
In cell 'validations'!B2 I have put formula =filter(C:C,len(C:C))
Via Data validations which reference 'validations'B:B the formulas are now accessible in any other cell to run the sample functions.
B:)
Since in any cell the formulaes in validations!B:B are accessible via Data validation, I created a data validation in one cell, then copied cell to other cells, to a total of 3 cells, in 'Sheet1' .
C:)
I then duplicated 'Sheet1' to create 'Copy of Sheet1' (which of course has a different sheetid).
D:) Experiment
1)
From the drop down in 'Copy of Sheet1'!B8 , I chose from the list: =RUN("getFileNamesFromFolderName"," ' Scarlett")
This wrote file names to sheet 'Copy of Sheet1'
From the drop down in 'Copy of Sheet1'!B7 I chose from the list =RUN("putValues","sample1","sample2","sample3")
And from the drop down in 'Copy of Sheet1'!B6 I chose from the list =RUN("setColors",ROW(),COLUMN(),10,15)
The experiment results:
Firstly, 'Copy of Sheet1'
Secondly,'Sheet1'
