Formula help!

Options
Rachel Mickelson
Rachel Mickelson ✭✭
in Formulas and Functions

Hello! I need help with a formula. I need to be able to have an "IF" formula with an "AND" and an "OR" included to reference two different columns.Β 

Below is what I currently have, and while it works, I haven't been able to add in an "OR" statement to account for another column that needs to be referenced. Any suggestions would be great!

=IF(AND(TODAY() > [End date (actual)]@row, NOT(Status@row = "Complete")), 1, 0)

Thank you!

· Share on FacebookShare on Twitter

Answers

  • Protonsponge
    Protonsponge Community Champion
    edited 08/01/24

    Hello,

    Would something like this work for you:-

    =IF(AND(OR(Status@row = "Complete", [Another Column]@row = "Test"), [End Date]@row < TODAY()), 1, 0)

    image.png

    I hope that is helpful to you in some way,

    Protonspounge

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!