Formula just stopped working

I have a formula that I have used for years on a sheet and it was working an hour ago and then all of a sudden it just stopped working, I went out the sheet and back in and . The formula is

=IF([Shop Order]@row = 0, (COUNTIF((RN:RN), RN@row )))

but instead of returning the value it says #INVALID COLUMN VALUE

Got it working it was something in another colum that threw off the shop order Column!

Find more posts tagged with

Formulas

Accepted answers

All comments

Anjanesh Vaidya

Hi @Julzbrownlie,
Please try using the corrected formula below:

=IF([Shop Order]@row = 0, COUNTIF(RN:RN, RN@row ))

Paul Newcome

Is that error present in even one cell within the RN column?

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.