Hopefully a pretty easy question that I need help with.....

Hi all,

I am newish to using formulas, and I am stuck. All I really need to do is have one column return as "true" based on the status. I am getting an error message. This will allow me to calculate my data in an Excel pivot table.

=IF(CONTAINS("COLUMN NAME",@row), 1, 0)

What am I missing?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Danielle Arteaga

Hi, Devon. We need a little more information to answer your question.

Generally, your formula should look something like this:

=IF(CONTAINS([Column Name]@row), 1, 0)

Column names go in braces [], not quotation marks. Also, you do not need a comma between the column name and the @row specification.

See if this helps. If not, can you share a little more information about what you want the column you're pointing to to contain?

Devon

ah, that makes sense, thank you Danielle! One additional (very important item I didn't include: it is a check box option. I am seeing some edits based on that directive online and it still isn't working/giving me an error message. Attaching the error, and on the form it is one check box for that request.

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.