Help with formula

I am working to port a process that is managed in Excel into Smartsheet.

I want to created a formula that will check two cells in the row, if they both show filled, I want to check the checkbox. If either or both are any other status, I want the checkbox to remain unchecked.

I want to convert this to a column formula. When I enter this into the cell, it works as expected:

=IF([Status One]1="Filled", IF([Status Two]1 = "Filled", 1, 0))

However, that formula will not convert to a column formula. When I change it to the formula below, I get #Invalid Operation.

=IF([Status One]:[Status One]="Filled", IF([Status Two]:[Status Two] = "Filled", 1, 0))

Can someone point out my error?

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

@Dawn_Cox

Column formulas can't have row number references. Use @row instead:

=IF([Status One]@row="Filled", IF([Status Two]@row = "Filled", 1, 0))

All comments

Jeff Reisman

@Dawn_Cox

Column formulas can't have row number references. Use @row instead:

=IF([Status One]@row="Filled", IF([Status Two]@row = "Filled", 1, 0))

Dawn_Cox

Thank you, @Jeff_Reisman

Much appreciated!

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.