How can I find out the source of failure for a column formula?

I'm creating a smartsheet that is a summarization of different sheets for charting purposes. I've created a formula to find out the total number of material that matches specific qualifications.

When I created the formula, it was working, but when I make is a column formula, suddenly the majority of the values have "Invalid Operation". All referenced columns are identical in data type and column data entry type.

Screencap of the sheet showing that some cells work and others don't. The 0 values are expected.

Screencap of the formula used.

Find more posts tagged with

Accepted answers

All comments

Lucas Rayala

Hi @PleaseHelpJay -- you're criteria can't contain a range -- when you are referring to a value in the range, you use @cell. Try this for your second criteria:

~~<>(@cell+" - USA")~~

Editing this -- I believe you just don't want to return values with "USA" in the Range 2? If so, your criterial should be:

NOT(CONTAINS("USA", @cell))

PleaseHelpJay

Hello @Lucas Rayala !

Thank you for your help! Just so that I understand the background to the reference, why would I put @cell? what does this reference?

Also I just tried with the update and the error code switches to Unparseable.

Best

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.