Auto-filling formulas in Sheet w/ Salesforce Connector
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
Check out the Formula Handbook template!