I'm using a formula to spill values from a column in a table on one worksheet to another column on another worksheet.
The table and column is called tblActiveProjects[Go Live Date]. I want to spill the values that meet the following criteria:
If I leave it at just not equaling TBD, I'm fine, but when I get into the month and year stuff, that's where it breaks down.
Is what I want possible?
The table and column is called tblActiveProjects[Go Live Date]. I want to spill the values that meet the following criteria:
- the month of the value in [Go Live Date] IS NOT less than the month of Today
- the year of the value in [Go Live Date] IS EQUAL to the year of Today
- the value in [Go Live Date] IS NOT equal to "TBD"
Excel Formula:
=FILTER(tblActiveProjects[Go Live Date],(tblActiveProjects[Go Live Date]<>"TBD")*(MONTH(tblActiveProjects[Go Live Date])<MONTH(TODAY()))*(YEAR(tblActiveProjects[Go Live Date]=YEAR(TODAY()))))
If I leave it at just not equaling TBD, I'm fine, but when I get into the month and year stuff, that's where it breaks down.
Is what I want possible?