And, Or, NOT(isblank) Formula help needed

Hi, I'm attempting to write a formula that would check a box in a specific column if the [De-prioritized?[check if yes]] column is checked OR the [Date Marked Complete] Column is NOT blank and [Date Marked Complete] column has a date more 30 or more days in the past.

Below is what I came up with, but am receiving a non-parsable message.

Any help you could provide would be appreciated!

=IF(OR(AND([De-Prioritized? \[check if Yes\]]@row = 1, ([Date Marked Complete]@row <= TODAY(-30),AND(NOT(ISBLANK([Date Marked Complete]@row)))))1,0))

Thanks!

Tags:

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓

    If you are saying your want the checkbox to be checked if De-prioritized?[check if yes] is checked OR (Date Marked Complete is not blank and is 30 days or more in the past) then use this,

    =IF(OR([De-Prioritized?\[check if yes\]]@row, AND(NOT(ISBLANK([Date Marked Complete]@row)),[Date Marked Complete]@row <= TODAY(-30))),1,0)
    
    

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!