Date Compare Formula

M Morgan
M Morgan ✭✭
edited 10/01/21 in Formulas and Functions

Hi All,

I had a closed discussion that ended up not being answered so I thought I would repost

I've been having a problem with a formula where I'm looking to compare two dates at a task level - the baseline finish date and the actual finish date. If the task is actually late (past the baseline finish), I want a checkbox auto-checked.

The formula I'm looking for will satisfy the following:

If the actual finish date is later than the baseline finish date, OR if the actual finish date is blank (because it's still in progress) but the calendar date (that matches the baseline completion date) has passed, the checkbox needs to be checked. Is there a formula anyone can help me with for that?

Let me know, thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!