Duration and finish dates

Gordon Menzies

Hello

Is it possible to create a Formula or another way to do the following

example:

Industry Injection mold making

I have allotted 5 days for a task. ie starting on Monday- finish Friday

once finished they move to the next operation. start on the following Monday

I have a check box to machine the parts. in progress another for completed

the operator finishes one day early . I would like to click the finish check box and have the finish date moved back a day. thus moving the next operation to start on Friday.

is it possible to have the predecessor also cleared

I would then like the next operation check box to move the start date up.

thanks for any help

Gord

Formula in smart sheet.jpg

Find more posts tagged with

Accepted answers

All comments

Ramzi K

Gordon, the End Date and Predecessor columns in a Smartsheet project plan cannot contain formulas, so there is no way to do what you want currently and have it reflected in the Gantt.

A suggestion is that once you mark something as complete, you can highlight the row with conditional formatting as a reminder to make the changes manually.

Cheers,

Ramzi

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.