I am typing in this formula and getting an error message. Does anyone know why?
=IF([Actual Sub Date]@row > DATE(2020,5,1)),if([Actual Sub Date]@row < date(2020,7,31)),"Q1 FY21","NA"
Please help!
Hi @Sandra Vulis Petrosyan
Your IF statements are closed prematurely which doesn't allow for the logic statements to execute.
Try this
=IF([Actual Sub Date]@row > DATE(2020, 5, 1), IF([Actual Sub Date]@row < DATE(2020, 7, 31), "Q1 FY21", "NA"))
As a rule of thumb, there will be at least the number of parentheses ending a formula as the number of IFs in the formula. Not always, but as a rule of thumb.
cheers,
Kelly
Thank you! Now I am trying to do it for entire FY but getting blanks
=IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 5, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2020, 7, 31), "Q1 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 8, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2020, 10, 31), "Q2 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2020, 11, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2021, 1, 31), "Q3 FY21"), IF([Actual Sub Date (Month/Day/Yr)]@row > DATE(2021, 2, 1), IF([Actual Sub Date (Month/Day/Yr)]@row < DATE(2021, 4, 30), "Q4 FY21")))))
Actually, it works! Thank you again for your help.
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.
