Is there a revised formula that will allow me to show more accurate training dates?

I have a formula in a training matrix that compares dates of when a document revises and when the training was carried out for employees.

=IF([Revision Date]@row > [employee]93, true, false)

However, this returns a red font date if the revision date is greater than the training date, even if the employee was trained prior to the finalization of the revision date. I am wondering if this formula could be modified to account for the revision date - 5 days to not flag trainings that happen just before the revision occurs, pre-emptive training before official revision.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!