Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Past Due with IF Formulas

    ✭✭
    in Formulas and Functions

    Hello,

    I am trying to create an IF equation that allows a column to be either "Past Due" or "Not Due" depending if the last inspection was more or less than 7 days that today's date. The column is not drop down but text format

    =IF(TODAY() > [Date Inspected]@row + 7, "Past Due"), IF(TODAY() < [Date Inspected]@row + 7, "Not Due")

    Is this possible?

    Thanks,

    Pete

    · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭

      Do you really need the second equation? wouldnt you just have the false side of your if statement be "Not due"?

      =IF(TODAY() > [Date Inspected]@row + 7, "Past Due", "Not Due")

      The formula you provided was close but had an extra IF statement that was not necessary. The correct formula only needs a single IF statement because you're handling two conditions: either it's past due or it's not.

      · Share on FacebookShare on Twitter
    • Community Champion

      @Pete Panos

      try simplifying it


      =IF(Today()>[Date Inspected]@row + 7,”Past Due”, “Not Due”)

      If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions