Automate Your Formulas for Every Row in your Spreadsheet
/ @theworkflow_
Tired of dragging formulas, copy pasting, or a coworker accidentally breaking all your formulas?! New Row, No problem! Learn the super power of ArrayFormula() and you'll be able to write one formula that generates for every row of data. Gone are the days of chasing down broken formulas in spreadsheets.
Learn how to constrain your ArrayFormulas dynamically here ( • New Row, No Work! Array_Constrain() - Auto... )
0:00 - Set up Explanation
0:20 - The Sample Data
1:00 - Automate the Formulas - Example 1
1:48 - Automate more Formulas - Example 2
2:18 - Use Cases
2:54 - Fool Proof / Error Handling
3:29 - The only thing to be careful of (Blocking the expanding formula)
4:03 - Handling the infinite formula (Constrain the Formula)
4:37 - Do the thing