User Profile
Medhi-RC
Copper Contributor
Joined Nov 18, 2022
User Widgets
Recent Discussions
If there is a certain Text -> CheckBox disappear
Hello, I would like to ask you if you know a function that could allow this : I have a dropdown list, I use a ComboBox, and depending on what element you have selected, texts appear/disappear. I have put conditional formatting for this, using white font, and cell are filled in white But, I would like also, that if you have selected a certain element in the ComboBox, you can't see the check box. For instance, if you have selected in the dropdown list (ComboBox) the element "Fish", you can see a checkbox, but you can't see this check box if you have selected "Dog". And the same way, if you have selected "Fish" or "Dog", you can/can't see this one. Could you help me, please?If a cell contain a specific text then remove text border
Hello, In my excel file, which is a template, my respondent has to make a choice between 3 options with a dropdown list. When he selects an element, it returns to cell D2 the element. For instance, if I select "Product Range" in the dropdown menu, it appears "Product Range" in D2. But, depending on this data, I would like that conditional element appears/ disappear. If you select Cost Center --> Name is hidden, if you selected Product Range --> Code is hidden. (formula : =IF($D$2="Product Range";"Name";""). But I would like to remove the border from cell E5 (it looks like a text box). Indeed, if Name is empty, the text box should be hidden. How can I add a conditional format to borders? Or maybe, there is a workaround? Thank you for your help, and have a nice day!Create FAQ on SharePoint - Discussion List
Hello, I would like to ask you a question, I am using the modern mode of SharePoint and I would like to create a Corporate FAQ. I would like to add: the required field to fill, such as "Category", "Subcategory", "Question title" and also Questions with details. I would like, everyone could comment/answer a question. But I also would like to have something like this : -the homepage, with categories and a "ask question" button or "New discussion", -pages which are category, which contains the link to subcategories pages, recent questions asked -in the subcategories, all questions included in this category But, when you are responding to a question, I would like to add pictures / excel file or even Power BI file I have not found this kind of FAQ for a modern version of SharePoint yet. So when they click on "Ask question" they should field required fields Thank you very much for your help, and have a nice day!Extract a Power BI Measure to Excel
Hello Everyone, I have some measures created in Power BI, which are KPIs ratings (related to a survey) I have an Excel File, which contains a column "KPI ratings". I have calculated my KPI average into Power BI, is that possible to automatically extract the average from Power BI (which is a DAX measure) and insert the result into an Excel cell? For instance, my DAX measure in Power BI is: "Quality ratings - 2022". I have a column in Excel, can we extract the name "Quality Ratings - 2022" and then fill a cell with the name? Finally extract the result, for instance in Power BI the ratings it's 75% (the result of the DAX function), and fill a cell in Excel with this result. Thank you for your help, and have a nice day!
