
Creator
2020-08-21
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
show values based on condition
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)
1,782 Views
1 Reply

Creator III
2020-08-21
03:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try flipping your data there. Try this:
=If(Date1>Date2,Name)
Then un-check include null values.
1,724 Views
