Trying to get formula to show blank in a cell if the date column is blank

Hello,

I am using this formula in a summary field to grab the most recent entry. I do this by have a 2nd column that converts the enter date into just the month format. If the date field is blank it causes an invalid data type which then populates in the summary field. Here is what I am using:

=INDEX([Member Service Level MTD]:[Member Service Level MTD], MATCH(MAX(COLLECT([Date of Service]:[Date of Service], Month:Month, "April", [Member Service Level MTD]:[Member Service Level MTD], NOT(ISBLANK(@cell)))), [Date of Service]:[Date of Service], 0))

I wasn't quite able to make the formula work to make my month column blank if there is no date in the Date of Service column. I want to get rid of the invalid data type.

Find more posts tagged with

Accepted answers

All comments

Leibel S

@John Loushin

Wrap your formula in the month column in an IFERROR function. Something like this:

=IFERROR( PUT YOUR FORMULA HERE , "")

John Loushin

Thank you so much! I must have been placing it in the wrong area or forgetting the comma after the wrapped formula.

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.