Auto populate text in a cell

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.




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.



3 Replies



Did you try



@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.

@Dan_Mc , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies