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!

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

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)

All comments

Sameer Karkhanis

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)

Rick_Bailey

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

Sameer Karkhanis

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\] )

Rick_Bailey

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)

Rick_Bailey

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)

Sameer Karkhanis

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.