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
-
If they have been working in that sheet with the same process but suddenly stopped, I would suggest reaching out to Support.
Answers
-
If they have been working in that sheet with the same process but suddenly stopped, I would suggest reaching out to Support.
-
Thanks. That's kind of what I thought but wanted to reach out here first.
-
Sorry I couldn't be of more help. Feel free to revisit this thread once you have found a cause/solution in case someone else runs into the same issue.
-
Were you able to get an answer/fix for this issue?
-
I did not. Smartsheet was not able to determine what the cause is and told me to monitor it and continue to check the cell activity log and to contact them with more issues.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!