Copy Date from one column to another in the same sheet

I'm facing a challenge.

I've got a schedule with Start & End Date, when new lines are added I usually go and manually copy the Start & End Date to the Target Start & Target End Date on the same sheet. Initially I can add a formula to copy that date across however what I don't want is for the Target Start and Target End date to also change when the user updates the Start & End Date coz that need to be the "Baseline" for the schedule.

I already looked at the Community similar issues and appreciate the option is available to copy row to another sheet and use "Vlookup" however, to do that requires additional effort.

Just wanted to know if there is a alternative fix?

Should you need further information let me know. Would really appreciate some assistance.

Thank you.

Find more posts tagged with

Accepted answers

Mark.poole

You could add an additional Hidden date row that the formula pulls from. That's the only other option I can really see

All comments

Mark.poole

You could add an additional Hidden date row that the formula pulls from. That's the only other option I can really see

yolandi.venter

That get's me thinking. Thank you Mark.

Mark.poole

You are welcome

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.