User Profile
Benjamin_Draper
Copper Contributor
Joined Sep 27, 2022
User Widgets
Recent Discussions
Re: Grouping TRUE/FALSE answers into a single cell.
Martin_Weiss Hi Martin, https://docs.google.com/spreadsheets/d/13KSL6890GFm1f5AHU85lToVy3Y7bPdNa/edit?usp=sharing&ouid=115599846954560676885&rtpof=true&sd=true. I am working on Excel 2016. Hope that helps. Let me know if you need anything else. Regards, Ben3.1KViews0likes1CommentGrouping TRUE/FALSE answers into a single cell.
Hi all, To preface, I am an Excel novice, so I apologise in advance for my ignorance. What I'm looking to do is create a tool wherin employees (contact centre) can select a checkbox of what they have completed in a call interaction and then based on the TRUE/FALSE answers of the checkboxes, it generates notes that they can copy/paste into other software. As an example: during the call, the agent updates a phone number, and email, and resets an online password. They would select the three checkboxes relevant to this, then excel would spit out notes like: -Updated the member's phone number. -Updated the member's email address. -Reset the online password. What I have so far is all of the options and a checkbox for each option which generates a T/F result. I am also able to change the T/F answer to spit out the desired notes. The problem lies in that it is not copy/paste friendly, as the cells are far apart. Is there any way to, for example, check which options are T/F and group only the TRUE answers together in one cell? Please let me know if you need any clarification on anything. Thanks in advance.Solved3.3KViews0likes3Comments
Recent Blog Articles
No content to show