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.

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots for context? Assuming you have conditional formatting in place, how exactly is that set up?

Andrée Starå

Hi @Jtbeck

I hope you're well and safe!

Can you share some screenshots of the conditional formatting rules? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.