Pipedrive + Smartsheets
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!!!
Help Article Resources
Check out the Formula Handbook template!