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?
Answers
-
@Diane Mooree I think this should work for you. If you create a helper sheet that has 1 row with two columns.
Column A (Date): =TODAY()
Column B (Checkbox): =IF(DAY([Column A]@row + 1) = 1, 1, 0)
Set an automation to run daily that copies the row to your summary sheet if the box is checked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!