using AND

Hi,

Beginning 2023 I found my formula to say 'Yes" in a column if the row was entered this month was doing it for the previous years month as well so not delivering a true result for entries of the "Current month".

Old formula.

=IF(MONTH([Customer reported date]@row) = MONTH(TODAY(0)), "YES", "NO")

I also have a formula doing the same for if the entry was this year

=IF(YEAR([Customer reported date]@row) = YEAR(TODAY(0)), "YES", "NO")

To replace the first formula I was trying to combine the two but keep getting an incomplete error?

Was trying the below, what am I getting wrong?

=IF(AND(MONTH([Customer reported date]@row) = MONTH(TODAY(0))),(YEAR([Customer reported date]@row) = YEAR(TODAY(0))), "YES", "NO")

Thank you in advance for any help.

Find more posts tagged with

Accepted answers

Julie Fortney

You were very close! It's just where you had your parentheses.

Try this: =IF(AND(MONTH([Customer reported date]@row) = MONTH(TODAY(0)), (YEAR([Customer reported date]@row) = YEAR(TODAY(0)))), "YES", "NO")

I moved one parenthesis as shown in bold above. That parenthesis closed out the AND formula, which we didn't want to do until we'd included the YEAR condition.

www.linkedin.com/in/juliefortney-pmp-smartsheetpartner-lssblackbelt

Heather_Verde

Try =IF(AND(MONTH([Customer reported date]@row) = MONTH(TODAY()), (YEAR([Customer reported date]@row) = YEAR(TODAY()))), "YES", "NO")

All comments

Julie Fortney

You were very close! It's just where you had your parentheses.

Try this: =IF(AND(MONTH([Customer reported date]@row) = MONTH(TODAY(0)), (YEAR([Customer reported date]@row) = YEAR(TODAY(0)))), "YES", "NO")

I moved one parenthesis as shown in bold above. That parenthesis closed out the AND formula, which we didn't want to do until we'd included the YEAR condition.

www.linkedin.com/in/juliefortney-pmp-smartsheetpartner-lssblackbelt

Heather_Verde

Try =IF(AND(MONTH([Customer reported date]@row) = MONTH(TODAY()), (YEAR([Customer reported date]@row) = YEAR(TODAY()))), "YES", "NO")

Michael Batt

Thank you, I can see just how close it was! Working nicely now!

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.