Add

I have 3 Sheets: #1 = Closeouts, #2 = Annual Incentives; #3 - Incentive Distribution

When a closeout is completed, data is entered on Sheet#3 - Inc. Dist. I have a Data Mesh to pull the data from the # 3 to populate Info on #2 Ann Inc. I am trying to get a formula or function that will do the following: When an entry is added to #1 Closeouts, add just 2 pieces of info to #2 Ann Inc

This diagram is Sheet #2 - It only contains data created at this point. Moving forward I need Job No and Project to populate when the same data is added to sheet #1 Closeouts

SHEET #2

SHEET #1

The formula to add this will eliminate having to do a manual entry on Sheet #2 when an entry is made on Sheet #1. Then it all works!

Hope this makes sense! I've confused myself!

Find more posts tagged with

Formulas

Accepted answers

Debbie Petersen

BINGO! THANK YoU!!

All comments

Brian Campbell

Hello, I have an odd workaround but might do what you are asking, create an additional column on both sheets that will combine the "Job No" with the word "Complete" on Sheet 1 (Closeouts) have this equal Job No + Status field. When the status field or whatever you use to indicate complete this will change this field to 19337Complete. Have this same field be listed on sheet 2 as Job No + "Complete". Just have these fields hidden, but have them be the basis for the data mesh instead of just the Job No. This way the datamesh will only occur when a closeout is marked complete. Let me know if you have any questions or need clarification.

Thank you

Michael

Debbie Petersen

BINGO! THANK YoU!!

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.