You’re offline. This is a read only version of the page.
2
| 2024 | |||
| January | February | March | April |
| Project A | Project B Projetc C |
||
| May | June | July | August |
| Project D | Project E Project F Project G |
||
| September | October | November | December |
| Project H | Project I | ||
Share
Report
All responses (
Answers (
With(
{
_Start: Date(Year(Today()), 1, 1),
_End: Date(Year(Today()), 12, 31)
},
With(
{
_Months:
ForAll(
Sequence(12),
{StartMonth: Date(Year(Today()), Value, 1)}
),
_Projects:
Filter(
YourProjectList,
YourStartDate >= _Start && YourStartDate <= _End
)
},
AddColumns(
_Months,
ProjectNames,
Concat(
Filter(
_Projects,
Month(YourStartDate) = Month(StartMonth)
),
YourProjectName,
Char(10)
),
MonthName,
Text(StartMonth, "mmmm yyyy")
)
)
)
Stay up to date on forum activity by subscribing.
