# And, Or, NOT(isblank) Formula help needed

Options
✭✭✭✭✭

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.

=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:

• ✭✭✭✭✭✭
Options

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)

```

• ✭✭✭✭✭✭
Options

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)

```
• ✭✭✭✭✭
Options

Thanks @Sameer Karkhanis ; I put this formula into the cell but it comes back as #UNPARSEABLE. Any advice? Thank you!

• ✭✭✭✭✭✭
edited 06/09/22
Options

Make sure the column names are spelled right and match with what you have in your sheet (For example, in my formula there is no space between De-Prioritized? and \[check if yes\] )

• ✭✭✭✭✭
Options

Thanks @Sameer Karkhanis ; I did validate they match, but just to make even simpler I shortened one of the column headers; still, it comes up as #UNPARSEABLE. Here is the revised formula

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

• ✭✭✭✭✭
Options

Hi, I figured out what the issue was-- I had a space between TODAY and (-30) for some reason.. The solution you posted worked (below). Thanks!

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

• ✭✭✭✭✭✭
Options

Glad you figured out the issue and good to know the formula now works.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!