IF/AND Statement

Hello,

I am trying to write a formula where a box will be checked if a date listed is older than 10 days, AND if the status in another column is listed as "UNAPPROVED." I got the date part down already, but I'm having trouble adding in the second expression. Anyone have any ideas? This is what I have now:

=IF(AND([Entry/Routing Date]1 < TODAY(-10), 1), ([INV Status]="UNAPPROVED"))

It's coming back with the error message #UNPARSEABLE.

Thanks for your help!

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @Meredith Kay

Hope you are fine, please try the following formula

=IF(AND([INV Status]@row = "UNAPPROVED", [Entry/Routing Date]@row < TODAY(-10)), 1)

All comments

Bassam Khalil

Hi @Meredith Kay

Hope you are fine, please try the following formula

=IF(AND([INV Status]@row = "UNAPPROVED", [Entry/Routing Date]@row < TODAY(-10)), 1)

Meredith Kay

Thank you so much! Works perfectly!

Bassam Khalil

@Meredith Kay

You are welcome, happy to help you

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.