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!