Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto-Copy Formulas

I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, itΒ seems to work. I noticed this, because all of theΒ IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else have a problem with this?
Comments
-
Were you getting errors? What specifically was the issue?Β
-
Hi there -Β
I was not able to replicate this. Did you have at least two rows above the newly inserted row that contained the formula?
Did you have numbers in the other columns for the formulas to reference?
Best,
Kara
-
Have you tested the "insert below" function? When right clicking on a row this function is the second option. It usually inherits formulas and formatting from the selected row.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives