Create a Risk Register in SharePoint....Not Excel 

😁

yes

You want to use a combo of regular drop down columns and calculated columns. Regular - Probability Regular - Severity Calculated - Probability Number (If probability is x, make this column y) Calculated - Severity Number (If severity is x, make this column y) Calculated - Risk Score (Probability number * severity number)

What's up, Blair. 1 - Did NOT create it using Power Apps or Automate 2 - Yes, you can link the Action Log with the Risk Log 3 - You CAN have the risk log update based on the action log. You'd want to use power automate for this. Does that help?

What's up Suriya, I'm gonna create the course for you. Coming soon!

Thanks you@@thesharepointhelpdesk

@@suriyakanta202 no problem. Glad to help!

@@thesharepointhelpdesk Hi When do you think I can have access to this please?

@@suriyakanta202 hey Suriya, I've been promoting it. There are three more slots left. Once three more people sign up, I'm gonna create it. I promise you're gonna LOVE it!

You want to use a combo of regular drop down columns and calculated columns. Regular - Probability Regular - Severity Calculated - Probability Number (If probability is x, make this column y) Calculated - Severity Number (If severity is x, make this column y) Calculated - Risk Score (Probability number * severity number)

I appreciate you replying @@thesharepointhelpdesk ! It was your drop down column I was particularly interested in, as when you selected the text, the options were nice and clear as they were colour coded (I like this way of selecting the text rather than number and let sharepoint assign number & calculations!)

aah - I was creating from list settings, but see I can create straight from the grid view screen which gives those options! (I figured this out by watching your next video on creating the action log)

@@TheVikkicope ok great!!

I don't see why not. Are you a Project Manager?

@@thesharepointhelpdesk Ugh, I wish, those were the days haha. I'm a director now and run a portfolio. Always looking for better tools to give the teams to keep the programs and projects on track!

@@kevint3478 I know what you mean...when you get promoted, but start to get further away from the thing you love. So idk if I'll do Udemy, but whatever I do, I'll reply to your comment here to let you know. I assume you and your team use the Microsoft 365 suite, correct?

@@thesharepointhelpdesk Yep! And Azure DevOps instead of Jira. (well, on most of my programs) Saw another of your videos and like that you started with, hey, you already have teams channel, why reinvent the wheel. Some of these SharePoint experts posting videos think everyone is starting from scratch like it's still 2010 . Anyway, keep up the great work!

@@kevint3478 haha! I appreciate that. Thanks for watching! If there's some content you'd like to see, let me know.

Tell me more.

I'm so sorry. Idk how I missed this message. I'm on LinkedIn, shoot me a DM: www.linkedin.com/in/therman-trotman-15790b33

Sorry about that. It's in the description. Here it is again: kjaconsulting.samcart.com/products/build-a-risk-register-in-sharepoint