Auto-filling formulas in Sheet w/ Salesforce Connector

Ian B
Ian B ✭✭✭
edited 12/09/19 in Formulas and Functions

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! 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!