simple comparison

I can't believe I have to ask this, but I cannot turn up a solid answer when I search.

I just want to compare Column2 value with Column1 value. I want the formula/result to be in Column3.

I get UNPARSEABLE. The best formula I could find was: =IF([TotalRegistered] = [RegistrationCap], "SOLD OUT", "").

The only thing I can think is that Column1 and Column2 are both linked in from another sheet. Is that the reason this won't work?

Find more posts tagged with

Accepted answers

Paul Newcome

You need to specify a row reference.

=IF([TotalRegistered]@row = [RegistrationCap]@row, "SOLD OUT", "")

All comments

Paul Newcome

You need to specify a row reference.

=IF([TotalRegistered]@row = [RegistrationCap]@row, "SOLD OUT", "")

wkhuser

Thank you so much!!

Paul Newcome

Happy to help. 👍️

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.