I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in

Options

I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column.

=PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5))

or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))

Both return incorrect arguments.

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓
    Options

    Are you sure you are looking for the "percentile" or maybe just the percent? If you want a percentile, you will need a numerical column as the source.

    Is it the case that you want to know what percent of responses that list "4 Months" also list "1-2" in the other column?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!