How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via


Hi All


I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me.

Did any of you faced a similar problem? What would be the solution?

Thank you


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!