Repeated Task

Hello all you wonderful SmartSheet users

I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed.

i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I have a sub task in this later drawing - but it's just a sub task. SmartSheet doesn't know its the same task that was completed previously, so it doesn't pull the associated data (as above).

Is there anyway to directly link this sub task to the initial one, so SmartSheet knows they are the same?

Find more posts tagged with

Sheets

Formulas

Automations

Project Management

Smartsheet

Accepted answers

All comments

Julie Fortney

Could you use cell formulas to pull this data from the drawing task above?

CJU

Hi Julie

I am less concerned about the dates than the % complete. Using predecessor as FF; the repeated task has the same end date as when it that task first appeared. Smartsheet still however thinks it is a new task, just with same end date.

I would like SmartSheet to know this is exactly the same task as was previously completed so all related data - especially % complete, would update automatically in every instance the task is repeated.

Julie Fortney

You could cell link the % complete also, but you're correct, there isn't a way for Smartsheet to consider it the same task.

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.