Help with formula

Dawn_Cox

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?

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))

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!