Can't get a new subscription again
I has a problem for get new subscription. Detailed my case: - In Apr 19, i deleted profile (my subscription expired in Apr 19, 2024). - Got email confirm for deleted and Invite to Dev Program. - Today (Jun 20), after wait 60 days for delete current profile. - I visit join developer page and join again. - But, I got same screen in Apr 19, it include a old subscription expried and no any button for register new subscription/subscriptions. - I deleted profile again (Jun 20)... Also, i read all document and faq in Microsoft Learn for Microsoft 365 Dev Program but can't help more. I try click to Support in Navigation(Menu) bar in top of page, redirect to Microsoft ServicesHub and can't use my account for login. And my question: How can register subscription again, and how can contact to support via email?
VLOOKUP help required
I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the project lifecycle entered by the user. =VLOOKUP(H4,Category,2,FALSE) – this works fine and is using Lookup table 1. On the main worksheet, the user will enter in a score for each of the Project Elements (ranging from 1- unacceptable to 5-excellent). What I need to do is – based on the Category, apply the appropriate Weighting factor to the Project Element Scores (lookup table 3) and output that value into another column (called Project Element Weighted Score). Lookup table 1: Lifecycle Category 1-Investigation 1-Conceive 2-Definition 2-Design 3-Implementation 3-Build 4-Production 3-Build 5-Frozen 4-Manage 6-Phase out Started 4-Manage 7-Phased out 4-Manage Lookup table 2: Category Project Elements Score Output value weighting 1-Conceive Personnel 5 5 1 1-Conceive Personnel 4 4 1-Conceive Personnel 3 3 1-Conceive Personnel 2 2 1-Conceive Personnel 1 1 1-Conceive R&D 5 5 5 1-Conceive R&D 4 4 1-Conceive R&D 3 3 1-Conceive R&D 2 2 1-Conceive R&D 1 1 1-Conceive Infrastructure 5 5 2 I have in the weighted score field on the main spreadsheet and a VLOOKUP formula that was working prior to introducing the Weighting by Category concept. I can’t figure out how to include a lookup to to get the category and the corresponding weighting factor and use the correct weighting factor to apply to the score. I hope I’ve been clear enough - I cannot send my spreadsheet as it has c
How do I manage my Microsoft Project? (notifications, deletion, and more)...
I finally got a license for Microsoft Project (instead of silly Planner which I cannot use for Agile Framework). However, I am still having some basic functionality issues with Microsoft Project Online. I am honestly trained on 2010 version of Microsoft Project, so a lot of these feature changes 1) How do I control notifications for Microsoft Project Online? First, I discovered there is these new notifications feature for Microsoft Project that sends out an email every time a even a sub-subtask (aka an action instance) is assigned. I do not want my coworker or the entire department to receive emails every time I edit a plan. (I mean 1 email is ok) but with how I work it can lead to like 60 emails.... So naturally I binged it which gave me this result.... https://answers.microsoft.com/en-us/msteams/forum/all/turn-off-sending-out-notification-to-all-members/84653dd8-187a-4178-9a94-96e96b86fca4 1. From the planning board, select the 3 dots (. . .) to the right of the plan's name. 2. Choose Plan Settings from the menu There are no settings under any of the 3 dots menu. So where are the notification settings for an entire project? 2) What is needed to access actual Microsoft Project Online? Normally I click on a project and simply edit it, but in the desperate search for the actual settings for a Microsoft Project.... I discovered today that I have a weird error. Something about permission to a SharePoint site. It did not give me this error before. I suspect that I might have to make my own PWA site. Can someone explain to me what this error is about and why the day before I could access Microsoft Project Online but now cannot? 3) How to delete a project? So, I was able to find a tutorial on this one, but I wanted to ask if there was a better way. https://answers.microsoft.com/en-us/msoffice/forum/all/deleting-a-project-from-project-for-the-web/a73789ef-b8be-4eb7-ba42-a9b2aaffe54b 4) How to control users that are part Microsoft Project Online? Because how many documents talk about need to be owner to control emails... I tried to make own group in hopes that will give me better control over notifications. But this led to a discovery that I am in like 15 different groups all with the exact same name as my section and members. So What settings in Groups are for a Microsoft Project Plan? Just an old fashion Project Plan user trying to understand how to use this confusing new Project version.Excel Table Appears to Automatically Expand but drop down list doesn't update
I used Excel 2013. I created a drop-down list that is based on an Excel Table via the Data Validation button on the Data ribbon. If I add or delete a row from the middle of the table, my associated drop-downs are updated automatically. However, if I insert a row of data at the very top or bottom of the list (range), even though the table appears to have expanded, the drop-down list does not update automatically. The Auto Correct options "Include new rows and columns in table" and "Fill formulas in tables to create calculated columns" are checked. None of the sheets on my workbook are protected.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.
