How to work with multiple criteria evaluation?

Christine Rosenberg

I want to create an evaluation for 5 people on 7 criteria in Smartsheet.

If I use form or Request Update workflow, then I can only create one input per item/line. However, I want 5 evaluations for each item/line. Do I create indended line and sum? Do I create seperate sheets for each person evaluating and then sum the evalution in an additional sheet?

Is there a functionality in Dynamic View, where I can do this?

This is an example, where I want the line with reference number 016 to be evaluated for Scientific novelty/Solidity/unmet needs/Market approach. In this dynamic view, I can only have one person check the boxes. How is it possible to have a matrix, where I can have 5 people check a box for ie scientific novelty for reference 016?

Genevieve P.

Hi Christine,

You are correct - this would require you to know who the reviewers are. I'm not quite sure I understand what it is you're reviewing - are you having these 5 people review the Applicant? Or the Title? And are they only doing this by checking a box?

If you don't know who the reviewer is, you could set up a generic form instead that's built from this sheet (this would be instead of the child-row solution above). Users don't need to be shared to a sheet to fill out a form, so there is no need for Dynamic View.

The form could have a restricted drop-down list for what it is that they are reviewing to choose from. (Note: If you don't want them to choose, you would need to set up individual forms for each option: one for Dorthes dukke, one for Postbud, etc. In this case, include the field in the form as a "hidden filed" and set the default value to be what the form should be used for. )

If you make the form restricted to those with a Smartsheet login, you can input a Created by System column to record the user who filled out the form automatically. In addition, you can set up an INDEX(MATCH formula in your sheet to return the reference number or applicant name, depending on what these refer to.

Then once all the reviews have come in, you can Sort the sheet to have the rows collected together, in order. You can either use a second sheet with cross-sheet references to pull different calculations or use the Sheet Summary field, depending on what information you're looking to gather. Another way to sort/filter the data collected would be to create a Report based on specific criteria.

In regards to comments, you could have this be a new column on your sheet, and add this to the form as well. For collecting all comments that have to do with one type of review, you could potentially use a JOIN(COLLECT formula in a different sheet to gather this information into one cell, but this might look quite large. I would suggest that creating a Report or Sorting the rows so the comments show up in order might be the simplest way to go.

If you want it to be obvious which comment pertains to which reference number, you could set up conditional formatting rules to change the colour of the comment cell depending on the reference number.

I know this is a lot of information, so please let me know if I can go into further detail for any of these elements. If this won't work for what you're trying to do, it would be helpful to hear a bit more about the overall picture and end goal of what this sheet is used for, along with any more screen captures or examples.

Thanks!

Genevieve