IF OR THEN Formulas

I'm having a hard time with adding a formula for the attached sheet. The formula should do the following: IF "Position Classification" = A-Adjunct THEN "Completion Date" is 5 years from "Date of Hire or Change" AND IF "Position Classification" = F-Faculty THEN "Completion Date" is 3 years from "Date of Hire or Change"

The formula would change the "Complete Date" automatically when the "Date of Hire or Change" is changed.

Thanks so much to anyone that can help me out!

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You will need to make sure that the text matches exactly.

    If you have "A - Adjunct" in the cell, but "A-Adjunct" in the formula, it will leave a blank.

    It also looks in your screenshot like the [Position Classification] column is a multi-select dropdown. Are there other selections in the same cell?

  • Jon Baier
    Jon Baier ✭✭✭✭
    Answer ✓

    @Kris Peeters Which formula did you use? Try Paul's first (he's a SS wizard 😎 )

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!