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

Doug Goss

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.

Andrée Starå

Hi @Doug Goss

I hope you're well and safe!

Have you tried converting it to a Column Formula?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!