Automatically add dated rows to a sheet
We manually create metric summaries to report out monthly metrics to more easily chart monthly measure data. That summary sheet has a format like below and each row contains SUMIF formulas that aggregates data from other sheets:
Month_Ending (Date) : Metric1: Metric2: Metric3: Metric4
Currently, this process requires that we remember to keep going in every quarter or every year and add more rows or the process breaks.
I can manually populate these rows but would love an automation that prevents me from having to remember to go in and add new dated rows.
Has anyone come up with a way to automatically create new dated rows?
Help Article Resources
Check out the Formula Handbook template!