Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there any way to ignore the active filters on a sheet, for a table with an if statement?
For example, I have a filters made on my app that mades AllocYear = 2018. But, at one of the app sheet's, there's table that discriminates some orders and I'm using something like this expression:
= If (OrdStat = 'CONFIRM' and Today ()> LateDisp and FinUnits <OrdUnits and InternalServPfeYn = 'N' and InternalServExternalPi = 'N', ItemOrd)
I wanted to add something that would ignore the fact that I have the AllocYear = 2018 made and would make me consider all the orders for AllocYear = 2018 and 2017.
Thank You.
It's seems to work better! Thank you, Sunny! i'll explore this option a little bit more.