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!
Best 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
-
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)
-
Thanks @Sameer Karkhanis ; I put this formula into the cell but it comes back as #UNPARSEABLE. Any advice? Thank you!
-
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\] )
-
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)
-
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)
-
Glad you figured out the issue and good to know the formula now works.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!