Pipedrive + Smartsheets

edited 12/09/19 in Formulas and Functions

When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter a starting and end date based off of the row above Predecessors and autofill a new Predecessors for the next row that will eventually be populated below it. 


I then have it setup so that it send a note back to Pipedrive with the Scheduled Date and updates anytime it is altered in Smartsheets. Please tell me the auto fill starting date and Predecessors is possible!!! 

Screen Shot 2018-11-20 at 1.31.14 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!