Convert to Column Formula Error

I'm trying to make the below formula a column formula. If I copy and paste the formula into cells, it works as expected.

=IF(OR([Status]1 = "Complete", [Status]1 = ""), "", "Yes")

Two issues, though:

1) The [Status]1 brackets are being automatically removed and reformatted as Status1

2) When I try to convert to a column formula, I get the error "The column formula syntax isn't quite right."

What am I doing incorrectly?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You only need the brackets when the column name contains a space, number, and/or special character. Your column name doesn't contain any of those things which means the brackets aren't needed which is why Smartsheet is removing them.

The reason it cannot be converted into a column formula is because you are using specific row numbers. Column formulas must use "@row" references.

You have

Status1

You need

Status@row

All comments

Paul Newcome

The reason it cannot be converted into a column formula is because you are using specific row numbers. Column formulas must use "@row" references.

You have

Status1

You need

Status@row

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.