Hi
I have a requirement to do validation checks for many columns and even for some columns I need to do the following checks few times with different column. The check I need to do is,
Column A must be present if Column B is present. In some cases I need to have this with many other checks like Column C have values more than 1000 etc
Eg:- If Income is over 10000, then IsTaxPaid column must be prese
Any suggestion for achieving this easily
Solved! Go to Solution.
hi @DtaViz,
you could use a formula and then a filter or directly filter with a formula like this one :
!isnull([clumn_A]) and !isnull([Column_B])
and you can add as many criteria as you need, tell me if it helped or you want me to explain more!