Hello,
I am learning how to use formulas to filter data from a table.
I have this formula and need some assistance updating it so that if B2 and/or D2 (date range) is blank, instead of showing nothing, it would gather the last 180 days of data from the table.
=IF(C1="","",FILTER(TData,IF(C1="All",1,TData[EMPLOYEE NAME]=C1)*(TData[AUDIT DATE]>=B2)*(TData[AUDIT DATE]<=D2)*IF(F1="All",1,TData[SHIFT]=F1)*IF(F2="All",1,TData[TYPE]=F2)))
If this is possible, I appreciate any help with this.
Thank you,
Nick
I am learning how to use formulas to filter data from a table.
I have this formula and need some assistance updating it so that if B2 and/or D2 (date range) is blank, instead of showing nothing, it would gather the last 180 days of data from the table.
=IF(C1="","",FILTER(TData,IF(C1="All",1,TData[EMPLOYEE NAME]=C1)*(TData[AUDIT DATE]>=B2)*(TData[AUDIT DATE]<=D2)*IF(F1="All",1,TData[SHIFT]=F1)*IF(F2="All",1,TData[TYPE]=F2)))
If this is possible, I appreciate any help with this.
Thank you,
Nick