Formula not calculating for each row automatically. Have to fill down.


Have a sheet that is populated by a form. The sheet has a column that has the formula:

=IF([Tier Score]@row <= 17, "Tier 3", IF([Tier Score]@row <= 25, "Tier 2", IF([Tier Score]@row >= 26, "Tier 1")))

But when someone submits a new row, the formula does not fill down to calculate. I have to manually fill down.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!