- write formulas for me (single cell but let me say in english what I want then give me the formula)
- do more complex things like "add another week" (1) insert new column (2) copy all formulas (3) adjust the fixed date
- Explain a sheet / formula / section - Help me understand where this value comes from
- do large scale formatting adjustments/alignments
- find discrepancies / inconsistencies
Your requirement is to be able to automatically add rows (add corresponding formulas to calculate the corresponding data) or filter data through AI, which may allow AI to create a new data (automatically generate corresponding rows and make the data simpler)