Formula not cascading to new form entries.


I have a survey and in my smart sheet, I have formulas and they all work but with every new entry I have to manually cascade it down to apply it to the rows below.

How do I make the formula apply for every new entry?

Thank you for your help !


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!