Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions