Formulas not carrying down to new rows


I have a sheet with formulas in most of the columns that should be carrying down to newly added rows but after several months of it working correctly, they no longer carry down. I have checked for blank rows and made sure the formulas are correct in each column and present in every row but after working for awhile, they just don't carry down any more. I am familiar with the process and have done this on numerous sheets but for this one sheet, it is no longer working. The rows are added using the Gmail SmartSheet add-on. I have searched the community for answers but can't find anyone who has had a similar issue. Any ideas?

Thank you


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!