Auto-filling formulas in Sheet w/ Salesforce Connector

Ian B

Hi All, 

I have a sheet that is connected to Salesforce opportunities using the Smartsheet-Salesforce connector. I'm trying to find a way to get my formulas to auto-fill in columns that exist in Smartsheet, but not in Salesforce when a new opportunity is added to Salesforce and subsequently populates the sheet in Smartsheet. Right now new opportunities are added to the bottom of the sheet in the next available row that doesn't have any data in it. Any help would be much appreciated! 

Morgan Marquez

If you're adding to the bottom of the sheet, make sure that there are no blank rows underneath the last row with formulas in it.

If you delete all the blank rows at the bottom of your sheet your formulas should pull down to new rows added.

Ian B

Blank rows were absolutely my problem. Thanks for the help Morgan!