I am not sure how to set up the formula to include blanks or >= 01/01/2023 from the same Term Date column.
I am hopeful that this is a quick fix and that someone will shed some light on it. Currently, the formula looks like this:
FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]=O1)*(Activity[Term Date]>=DATE(2023,1,1))*(Activity[Tier]>=0.25),"")
I need to incorporate the rows where there are blanks in the Term Date.
I am hopeful that this is a quick fix and that someone will shed some light on it. Currently, the formula looks like this:
FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]=O1)*(Activity[Term Date]>=DATE(2023,1,1))*(Activity[Tier]>=0.25),"")
I need to incorporate the rows where there are blanks in the Term Date.