In Google Spreadsheet, finding what formulas reference a given value
I would like to find out which cells have formula dependencies in a large
spreadsheet. I am looking for a way to do something like OpenOffice
Tools>Detective>Trace dependents
and
Edit>Find & Replace>Search in formulas
or a way to create a trigger in GAS that gets called when a given cell
value is referenced and can identify the source of the reference.
No comments:
Post a Comment