Nested Formulas

Hi, I am counting the number of days in a calendar month, my formula works until I get to August. Am I missing something or is there a limit on how formulas I can nest? Thanks

Here's my nested formula…

=IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "January"), "31", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "February"), "28", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "March"), "31", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "April"), "30", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "May"), "31",

IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "June"), "30",

IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "July"), "31", "NA")))))))

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @rodel.policarpio,

What error are you getting? There's a 4000 character count limit for a cell, and you're only at 571 so you should be fine.

rodel.policarpio

Not sure what happened, but it works now. Maybe I just needed to refresh the browser or maybe a computer reboot. Thanks for the feedback, though. And good to know the character limit. Have a good day.

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.