Help fix error with if and formula

I am trying a formula and keep getting an error. Here is what I am trying =IF(and([Billing Status as of 04/10/2023]="Active",[Line Installation Date]@row="N/A"), "Unknown", IF(and([Billing Status as of 04/10/2023]="Inactive",[Line Installation Date]@row="N/A"), "N/A",IF([Installation Year]@row > 1988, "Yes", IF([Installation Year]@row < 1988, "No", "")))

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Chevon Brownell

I’m assuming you’re getting an Unparseable error?

you are missing an @row in your first AND

kelly

All comments

Kelly Moore

Hey @Chevon Brownell

I’m assuming you’re getting an Unparseable error?

you are missing an @row in your first AND

kelly

Chevon Brownell

Thank you! Sometimes it just takes a second set of eyes.

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.