Issue with If Statement

Not sure if it is possible, I have tried some basic if statements but not getting anywhere.

Looking for some help please, trying to get an if statement to work in the Validation Status column, where if the due date is over 7 days the status column is populated with 'overdue', or if the due date is within 30 days then the status column is populated with 'close to due date' or the status column is populated with complete' when a date is entered into the date documentation submitted on teams column.




Tags:

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi @DRuscitti


    I assume you are expecting a status to appear when the due date is in the next 7 days to be overdue and when it is in the next 30 days to say close to due date. If that is the case, you can use this formula

    =IF([Date Document Submitted on Teams]@row <>"", "Complete", IF([Due Date]@row < TODAY(7), 'Overdue", IF([Due Date]@row <= TODAY(30), "Close to due date")))


    The column will remain blank in this case, if the due date is over 30 days from today.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!