Nested IF/AND Formula

Clay Watkins

I'm receiving an #UNPARSABLE error for the following formula:

=IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1",

IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2",

IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))

Based on the examples of similar formula, I think this is correct. What am I not seeing?

Find more posts tagged with

Formulas

Accepted answers

All comments

Mark Cronk

Your syntax looks right. When you place your cursor in the formula does it and the associated columns light up? Put each piece of the if statement into it's own row. Do they all produce a result?Check your column names. Confirm your end date column is set as a date. If none of that works, deleted the formula, save, and then retype it.

Mark

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.