Home

Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-783738%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783738%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20to%20create%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20this%2C%20so%20i%20apologize%20in%20advance%20if%20my%20wordings%20are%20off.%20Any%20help%20will%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20what%20i%20need.%20I%20attached%20a%20document%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20check%20marks%20are%20put%20into%20cells%20from%20the%20first%20page%2C%20names%26nbsp%3B%20should%20then%20populate%20the%20cells%20to%20the%20corresponding%20sheets%20under%20the%20AM%20driver%20or%20PM%20driver%20columns%20in%20the%20second%20page.%20Keep%20in%20mind%2C%20every%20sheet%20is%20separate%20and%20are%20in%20Ledger%20form.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20which%20will%20be%20easier%2C%20keeping%20every%20sheet%20separate%20or%20have%20all%20sheets%20under%20one%20workbook%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-783738%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784477%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784477%22%20slang%3D%22en-US%22%3EI%20would%20indubitably%20be%20easier%20to%20suggest%20an%20appropriate%20formula%20if%20you%20attach%20your%20sample%20Excel%2C%20rather%20than%20Word%2C%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-784700%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-784700%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385647%22%20target%3D%22_blank%22%3E%40aisa313%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EThere%20are%20different%20ways%20of%20creating%20a%20YES%2FNO%20field%2C%20or%20a%20Checked%3FUnchecked%20box%20or%20a%20CheckMark%2F%20XMark%20options.%3C%2FP%3E%3CP%3EI%20explained%20all%20these%20methods%20in%20details%20in%20the%20following%20video%20Tutorials%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1991724810%22%20id%3D%22toc-hId-1991724810%22%20id%3D%22toc-hId-1991724810%22%20id%3D%22toc-hId-1991724810%22%20id%3D%22toc-hId-1991724810%22%3ECreating%20a%20Check%20Mark%20or%20an%20X%20mark%20using%20Icon%20Sets%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqKfk4wdtDTc%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqKfk4wdtDTc%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId--560432151%22%20id%3D%22toc-hId--560432151%22%20id%3D%22toc-hId--560432151%22%20id%3D%22toc-hId--560432151%22%20id%3D%22toc-hId--560432151%22%3EUsing%20Combo%20Box%20To%20Create%20a%20Check%20Mark%20or%20an%20X%20Mark%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D837XYZApm1s%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D837XYZApm1s%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1182378184%22%20id%3D%22toc-hId-1182378184%22%20id%3D%22toc-hId-1182378184%22%20id%3D%22toc-hId-1182378184%22%20id%3D%22toc-hId-1182378184%22%3EExcel%20Calculations%20Using%20a%20Check%20Box%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqctkwUnle4M%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DqctkwUnle4M%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795985%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795985%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20it%20is%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E.%20Hope%20this%20makes%20it%20easier%20to%20understand%20what%20i%20need%20done.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-795986%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795986%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%2C%20here's%20the%20attachment%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796001%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796001%22%20slang%3D%22en-US%22%3E%3CP%3EThank%26nbsp%3Byou%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%2C%20the%20videos%20help%20with%20some%20of%20the%20issues%20i'm%20trying%20to%20resolve%20which%20i've%20used%20already.%20However%2C%20still%20need%20to%20figure%20out%20how%20to%20populate%20the%20names%20from%20the%20weekly%20schedule%20to%20the%20corresponding%20daily%20schedules%20and%20shifts%20depending%20on%20which%20cells%20has%20check%20marks%20on%20the%20weekly%20schedule.%3C%2FP%3E%3C%2FLINGO-BODY%3E
aisa313
New Contributor

I need help to create a formula.

 

I'm new to this, so i apologize in advance if my wordings are off. Any help will be appreciated.

 

Here is what i need. I attached a document

 

As check marks are put into cells from the first page, names  should then populate the cells to the corresponding sheets under the AM driver or PM driver columns in the second page. Keep in mind, every sheet is separate and are in Ledger form. 

 

Also, which will be easier, keeping every sheet separate or have all sheets under one workbook

 

 

 

 

5 Replies
I would indubitably be easier to suggest an appropriate formula if you attach your sample Excel, rather than Word, file.

@aisa313 

Hi

There are different ways of creating a YES/NO field, or a Checked?Unchecked box or a CheckMark/ XMark options.

I explained all these methods in details in the following video Tutorials:

 

Creating a Check Mark or an X mark using Icon Sets

https://www.youtube.com/watch?v=qKfk4wdtDTc

 

Using Combo Box To Create a Check Mark or an X Mark

https://www.youtube.com/watch?v=837XYZApm1s

 

Excel Calculations Using a Check Box

https://www.youtube.com/watch?v=qctkwUnle4M

 

Hope that helps

Nabil Mourad

In this training we learn how to create a Yes or No field, a Check mark or an X mark using conditional formatting and Data Validation
You might think a check box is just allowing you to select between 2 options... But, we can go far beyond that and use a check Box to perform calculations in Excel: Apply a discount, shipping cost or a Tax amount. If you use it in a dashboard, you can add interactivity to your setup.
Whether you want to enrich a Dashboard or just want to get quick insights about your data, you can use a Combo Box and have it deliver a Check Mark or an X Mark in a Cell

Here it is @Twifoo. Hope this makes it easier to understand what i need done. 

Sorry@Twifoo , here's the attachment

Thank you @nabilmourad, the videos help with some of the issues i'm trying to resolve which i've used already. However, still need to figure out how to populate the names from the weekly schedule to the corresponding daily schedules and shifts depending on which cells has check marks on the weekly schedule.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies