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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!