How to copy formulas to a column and keep formatting?
I've searched and found a few different answers to this question, however none of them are working. I have the following table in my Smartsheet and when I set it up it had the correct formulas, somehow the formula changed and instead of it looking at the range from row 1 to 388, it was looking at row 346 to 388. I tried correcting this but it won't let me keep the same range for the entire column, it changes and skips to the next, so the first formula row includes the correct range, then the second row will be range 2 to 389, and so on, and so forth. The example below is from someone refreshing the spreadsheet and all the rows that had been moved manually to the top of the sheet, moved back to to the bottom, not sure why that keeps happening, but it causes the formulas to change. This just isn't doing what I expected, and it's frustrating. Please help!
Answers
-
You could avoid this by creating a parent row for this top portion, indent each of the rows you want included, then use a CHILDREN reference for your range.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!