Hi @Benn_Bennett
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
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
)