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.
Name | Date1 | Date2 |
ABC | 8/21/2020 | 8/24/2020 |
DEF | 8/22/2020 | |
HIJ | 8/23/2020 | 8/20/2020 |
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.