How to show earliest date from 2 separate rows

Ask the Community
#1

Hi! I want to show (and then sort later on) the earliest date of two.

The situation: I have dates that meetings are due, and dates that meetings are scheduled. I need to see both so that I know how to plan accordingly.

The table:
Row Headers:
Name | Due Date | Scheduled Date | Earliest
Bob | 3/24/21 | [blank] | 3/24/21
Sue | 2/24/21 | 1/24/21 | 1/24/21

I’m looking for the formula I’d need on the “Earliest” column, assuming there will be blanks.

Thanks!

#2

Hi @Benn_Bennett :slight_smile:
I think that a simple if > would be enough for your case!
Formulas in earliest column would be something like
“If duedate>scheduledate, duedate, scheduledate”
It’s basically, if first is bigger write that, if not write the other

Can this solve the problem for you? :slight_smile:

1 Like
#3

To handle the blanks, tweak Mario’s approach with another check for blank scheduled date. The simple comparison will work in all situations except for “a blank schedule date with chosen due date.” So we need to check for that condition too.

IF(
  duedate < scheduleDate OR scheduleDate.isBlank(),
  duedate,
  scheduledate
)
2 Likes