The dreaded #invalid data type

Hi guys,

I'm progressing with my basic formula however what do i need to add into the below formula as an example so i don't get the unsightly #invalid data type in a cell just because the start date is blank?

=IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@row) = 4, "April", IF(MONTH([Start Date]@row) = 5, "May", IF(MONTH([Start Date]@row) = 6, "June", IF(MONTH([Start Date]@row) = 7, "July", IF(MONTH([Start Date]@row) = 8, "August", IF(MONTH([Start Date]@row) = 9, "September", IF(MONTH([Start Date]@row) = 10, "October", IF(MONTH([Start Date]@row) = 11, "November", IF(MONTH([Start Date]@row) = 12, "December"))))))))))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Dan W

IFERROR. Toss that in the front and the value you want if an error occurs at the end. I just put 0. You could put "" to leave it blank

=IFERROR(IF(MONTH([start date]@row) = 1, "January", IF(MONTH([start date]@row) = 2, "February", IF(MONTH([start date]@row) = 3, "March", IF(MONTH([start date]@row) = 4, "April", IF(MONTH([start date]@row) = 5, "May", IF(MONTH([start date]@row) = 6, "June", IF(MONTH([start date]@row) = 7, "July", IF(MONTH([start date]@row) = 8, "August", IF(MONTH([start date]@row) = 9, "September", IF(MONTH([start date]@row) = 10, "October", IF(MONTH([start date]@row) = 11, "November", IF(MONTH([start date]@row) = 12, "December")))))))))))), 0)

https://help.smartsheet.com/function/iferror

CAS

Thanks Dan,

I understand now appreciate your help.

I tweaked the formula to the below so it just leaves it blank.

Dan W

Cool deal happy to help!

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.