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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!