SOLVED
Home

Auto populate text in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-708877%22%20slang%3D%22en-US%22%3EAuto%20populate%20text%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708877%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20have%20text%20auto%20populate%20in%20a%20cell%20based%20of%20off%20three%20cells%20in%20the%20same%20row.%26nbsp%3B%20I'm%20want%20to%20use%20it%20a%20checklist%20feature%20in%20a%20progress%20tracking%20document.%26nbsp%3B%20The%20idea%20is%20the%20row%20represents%20a%20job%20and%20each%20of%20the%20three%20columns%20is%20a%20task%20that%20must%20be%20done%20for%20the%20job%20to%20be%20completed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20386px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119809i0FDC24E5D187BE85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAbove%20is%20what%20I%20would%20like%20to%20have.%26nbsp%3B%20The%20E%20Column%20is%20the%20cells%20I%20would%20like%20to%20have%20the%20%22Y%22%20or%20%22N%22%20auto%20populate.%26nbsp%3B%20%26nbsp%3BI%20have%20tried%20to%20use%20IF%20and%20IFS%20functions%20with%20no%20luck.%20Is%20there%20any%20other%20functions%20I%20can%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20much%20appreciated%20even%20if%20it%20is%20that%20I%20can't%20do%20it.%26nbsp%3B%20Then%20at%20least%20I%20will%20not%20be%20chasing%20my%20tail%20and%20can%20move%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-708877%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
Dan_Mc
New Contributor

Hello all,

 

I'm trying to have text auto populate in a cell based of off three cells in the same row.  I'm want to use it a checklist feature in a progress tracking document.  The idea is the row represents a job and each of the three columns is a task that must be done for the job to be completed.

 

Capture.PNG

 

Above is what I would like to have.  The E Column is the cells I would like to have the "Y" or "N" auto populate.   I have tried to use IF and IFS functions with no luck. Is there any other functions I can use?

 

Any help will be much appreciated even if it is that I can't do it.  Then at least I will not be chasing my tail and can move on.

 

Thanks

3 Replies
Solution

@Dan_Mc 

 

Did you try

=IF(COUNTIF(B2:D2,"Y")-3,"N","Y")

?

@Sergei Baklan 

 

I did not try that way.  Thank you very much Sir.  This will save my group and myself alot of time.

 

once again thank you.

Highlighted

@Dan_Mc , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies