Need help with IF formula using dates

laura.buchanan
laura.buchanan ✭✭✭✭

We want to know if someone's annual review is "due"

The Update date is when they upload the annual review and this populates from completion of a form. This is working correctly.

The "next due date" is when it is due and this is working correctly.

The problem is with the "testing IF formula for update" column formula.

The current formula works to say if they upload it prior to the due date it is due and if they upload it after the due date it is not due.

What I prefer to say is if they upload it within 30 days prior to the due date, it is also not due.

=IF([Update Date]@row <= [Next Due Date]@row, "due", "not due")

Can you assist?

Thanks!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!