Permutations & Combinations

Pestomania
Pestomania ✭✭✭✭✭
edited 03/24/25 in Formulas and Functions

Hello,

I am trying to create an automation or formula to run permutations based on test results. Some of the tests I run could be four columns some could be 10. I am trying to run the formula against the columns to identify the following answers:

  1. How can I run permutations against all of the results and determine the top 5 highest combo likelihood?
  2. How can I run the top 5 highest likelihood of Result 1, Result 2, Result 3, Result 4 based on historical data?
  3. How can I determine the day of the week that there certain combinations are most likely?

I am trying to determine different patterns in the results to identify if there are any variations occurring from different days, different results, etc.

Columns:

| Date | Result 1 | Result 2 | Result 3 | Result 4 | Concatenate Formula |

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!