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!!!

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

Find more posts tagged with

Calendar View

Formulas

Gantt View

Project Management

Accepted answers

All comments

Andrée Starå

Hi,

Interesting, but unfortunately I don't think it's possible except maybe with the API. I'll get back to you if I think of something that could work.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.