Consolidate Columns in a Trendline Report

Context: I have created a trendline report that counts the number of projects started each month. I've done so by building out three separate columns that determine the month and year so that I can then plot it on a trendline graph with a 2024/2025 series.
The Chart:
How the data is organized:
Month Formula:
=IF(MONTH([Start Date]@row) = 1, "01. January", IF(MONTH([Start Date]@row) = 2, "02. February", IF(MONTH([Start Date]@row) = 3, "03. March", IF(MONTH([Start Date]@row) = 4, "04. April", IF(MONTH([Start Date]@row) = 5, "05. May", IF(MONTH([Start Date]@row) = 6, "06. June", IF(MONTH([Start Date]@row) = 7, "07. July", IF(MONTH([Start Date]@row) = 8, "08. August", IF(MONTH([Start Date]@row) = 9, "09. September", IF(MONTH([Start Date]@row) = 10, "10. October", IF(MONTH([Start Date]@row) = 11, "11. November", "12. December")))))))))))
2024 Formula:
=IF(YEAR([Start Date]@row) = 2024, "2024", "")
2025 Formula:
=IF(YEAR([Start Date]3) = 2025, "2025", "")
Question:
To get the results I wanted, I had to create three separate columns (for the data I will be working with, the only user data that exists is the start date). However I want to create a similar to chart for Go-Live and Completed dates. Will I have to create 3 separate columns for both the Go-Live and Completed Dates or is there another way to produce the results I want without having to add additional columns?
Thanks!
Answers
-
How exactly are you charting the data? Are you putting it in a grouped report, or are you using a separate sheet with formulas containing cross sheet references?
-
Hi @Paul Newcome,
So the data will be in on sheet, I will then group the data in a report and that's how I create the trendline in the dashboard.
The formulas would simply be in columns I would add to the source sheet.
Hope this answers your question, thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!