Need Help with IF and IFERROR

Hello,

I have the IF part of the statement working just fine

=IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No") - basically it is evaluating if the next month from today is the same month as when the next maintenance is due. In rows where there is not yet data I am getting INVALID DATA TYPE error, so I would like those cells to say "No Data Yet".

I have tried to combine these two functions several ways and I'm just not getting it correct. Can someone please help?

Thanks,

Ashley

Find more posts tagged with

Formulas

Accepted answers

All comments

KPH

Hi @Ashley McAdoo

The syntax to add IFERROR is

=IFERROR(IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No"), "No Data Yet")

This will remove any error messages. However, in your case, you might want to use ISDATE instead. Your formula will return Yes if both cells are blank and No if one is blank and the other is not. As this is not an error, the "No Data Yet" message won't appear.

If you use ISDATE, you can check both cells have dates in and return the message if they do not. The formula for that is:

=IF(AND(ISDATE([NEXT Month Quarterly from Today]@row), ISDATE([NEXT Month Quarterly Due Number]@row)), IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No"), "No Data Yet")

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.