Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show Table with values if Date 2 is < Date 1..but I do not want to eliminate rows if Date2 is blank.
Output would be 2nd and 3rd row from the table.
I tried below expression but it eliminates rows, if date 2 is blank as well.
if(Date2 < Date1, Name)
You can try flipping your data there. Try this:
=If(Date1>Date2,Name)
Then un-check include null values.