Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Next Review Due doesn't take into account Last Approval Date

Answered
Request Demo

The auto-calculated 'Next Review Due' field for a document is calculated based on Frequency of Review, Review Month and Review Day; however, I have a document with a last approval date of January 20th, 2020. In these cases, I would want the Next Review Due field to function similar to an IF statement. For example, if the last approval date is very old, then I would want the Next Review Due field to calculate as "ASAP' or something along those lines. I have included a screenshot below. Is there a solution already built for something like this?

0

Comments

4 comments

Date Votes
  • Permanently deleted user

    Slight update to the post - we actually need the Next Review Due field to be based on A) Frequency of Review and B) Last Approval Date. How do I go about changing this auto-calculated field?

    0
  • Mike

    Thanks for all the info, Jack. I'm having our experts look to see if they have a solution for you. Hopefully we'll have something for you soon. 🍻

    1
  • Mike

    Quick update for you here.

    This is a custom graph calculation in your account and your CSM and team would need to see if it is doable. We recommend you reach out to your CSM letting them know your are looking to do this. Fingers-crossed this is possible.
     
    Sorry I could not be of more help here. Do let me know if you have any questions for me. Thanks much and happy Friday!
    1
  • Permanently deleted user

    Thank you very much for looking into this. I figured we'd have to reach out to our CSM but wanted to check here first.

    0

Please sign in to leave a comment.