RAID Log

Hey All,

I love the functionality of a RAID Log inside of excel. It's simple to move between the tabs and keep up to date with what is going on with my projects. I'm struggling to find a good way to use Smartsheet in a similar way. Currently I have made a sheet for each of Risks, Actions, Issues, and Decisions, and I have them stored in a folder and on a Dashboard for quick reference. But it's not ideal and is still cumbersome to switch between each. Has anyone found a good solution to use a tool like a RAID log in Smartsheet?

Find more posts tagged with

Comments

bukolatadio

Hi Cduncan,

I use Smartsheet for my RAID log. You can create a filter in the main sheet for open, realised or close risk or whatever the options are that you've got for your status. that way you are only seeing what you want to see per time and not the whole log.

We have risk, issues, actions and decision sheet separately and filters are applied by each person that has access to the log based on what they need to see - This doesn't in anyway affect the views of others because the filter isn't shared.

Hope this helps

Andrée Starå

Hi,

This might help:

https://www.smartsheet.com/all-risk-assessment-matrix-templates-you-need

https://www.smartsheet.com/free-risk-management-plan-templates

https://www.smartsheet.com/risk-register-templates

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I keep all line items on 1 sheet and use reports to break it out by type.

Alex Richter

https://community.smartsheet.com/discussion/comment/190311#Comment_190311

Do you have sorting issues with multiple users using the same sheet? For example, I understand filters can be applied on a per-user (collaborator with Edit access) basis, but if one user sorts the sheet and saves, I believe that affects everyone's view. This may depend on the number of users using the sheet, concurrently.

404.IRL

I think the ask maybe what I'm wondering as well - Risk/Issues/Decisions/Actions all typically have different fields suited for the purpose of the log. i.e. a Risk log would have columns such as Likelihood, impact, severity, etc. Where a Decision or Action log would not.

Can columns be hidden or shown based on cell content? For example, on my log I have I-###, R-### to distinguish between issues and risks. If the column "log type" is, say risk, is there a way to have corresponding/selected columns programmatically shown or hidden based on log type?

jgalus

https://community.smartsheet.com/discussion/comment/310875#Comment_310875

I agree - It seems like a catch 22 in Smartsheet.

I can either have one sheet to view all RAID items, but it's going to have a TON of columns. Or I can have broken out sheets be more specific, but then I have to jump between sheets when reviewing the log.

Marc Shecter

@jgalus and @404.IRL -- This is a challenge I faced too. My work around, since columns in sheets can't be hidden programmatically, is to use an automation that fills in "N/A" in not applicable columns based on the type of item being entered. For example, when Type selected == Decision, the automation puts N/A into the Mitigation column.

An additional thing I could do, just haven't had time, is to use conditional formatting so that all the cells with "N/A" are painted black so that there is an even more clear indicator that the cell isn't used for that row.

Sign in to join the conversation!

Quick Links

Trending discussions

Preserve cell data BEFORE Update Request is completed
Hi, I'm trying to figure out how to preserve cell data BEFORE an Update Request is executed. I was hoping to find functionality that would allow me to change the value of a cell in helper column WITH the value of the cell that is going to be updated once the Update Request is sent and subsequently executed.
Filtering for Linked Cells
I am trying to run a report for all of the cells in my "Last Contact Date" column that are not linked to another cell. We have separate teams who are populating separate sheets (SS Logs) so we can link the dates back here, but until they do, we'll just see the dot indicating it's linked with a blank value. The full sheet…
User Activity
I've been wondering about this for awhile, is there a place where you can find your user activity for any comments, or questions you've helped answer etc.. I know there is a Activity in your Profile for badges and achievements but im looking for your activity within the community. Ex: I've answered a question, and now its…