Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Compare Pre and Post Survey Results

I have a pre class survey and a post class survey. The surveys include both likert scale and fill in the blank questions. I would like to compare the data from the pre class survey to the post class survey in order to analyze and create metrics on improvement.

Any ideas on how to actualize this?

Answers

  • ✭✭✭✭

    Are your surveys in different sheets? then use an Index match cross sheet formula to bring the results in the original sheet, then you can build more columns formula as you wish for your results.

    You can also set up a 3rd metric sheets and similarly use index/match to bring the results in this sheet.

    https://www.smartsheet.com/content-center/best-practices/tips-tricks/3-formulas-look-up-data-smartsheet

  • The survey results are all currently going into one sheet. However, we want to be able to compare the improvement from the pre class survey to the post class survey : create metrics such as; Associate noted a 12% increase in knowledge of skill from pre class survey to post class survey.

    The questions are the exact same on the pre and post class survey.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • I have a pretty basic sheet that I am using to develop a formula, and am encountering an issue I haven't seen before. The formula isn't including my second row for some reason. It isn't a huge issue f…
    User: "jjg279"
    Answered ✓
    9
    2
  • I'm sure that this is an easy fix but I've tried a bunch of different ways and can't get this to work. I need to get the max date from a sheet to feed it into my meta data sheet (dates are stored in d…
    User: "susanmgfin"
    Answered ✓
    8
    2
  • I need help to come up with the risk formula. I tried many different formulas and tried to modify it but just can't seem to have desired results. So these are the conditions I MUST meet: Program is a …
    User: "Ronak"
    Answered ✓
    29
    6