Bring value of A1 from all active sheet in to Master report

google-sheets-formula

Solution 1:

You can use this custom formula:

function getF1F3Data() {
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets()
                             .filter(sheet => sheet.getSheetName() != 'main');
  return sheets.map(sheet => [sheet.getRange("F1").getValue(), sheet.getRange("F3").getValue()]);
}

output

Matches all sample data put into Sheet2 and Sheet3.

Related

Move cursor of JTextField or JComboBox to the start
Creating or finding an alternative for fuslogvw.exe, aka Fusion Assembly Binding Log Viewer
Copying / Cloning an ActiveStorage attribute
Vue3 / typescript accessing properties
Change cursor VB.NET
show that if ${a_n} \to a$, and $a>0$, then $\exists N$ such that $a_n>0$ for $n \ge N$.
Convergence or divergence
Show that a simple inequality holds: $a<b$ implies $\frac ab < \frac{a+1}{b+1}$
Prove that $\lim_{n \to \infty} \sqrt[n]{a} = 1$ using only the basic properties of sequences
Normal Random Variable
Fourier series identity
Prove $\forall K > 0: \lim_{n\rightarrow\infty} \sqrt[n]{K} = 1$ [duplicate]