Requesting help with syntax of formula with multiple ranges

Options

Background: There are years (0 through 5) that have processes (1 through 25) and each process has roles (1 through 10). In the attached image, I'm adding a formula in the Test_A1 that should check within all roles/processes per year to determine if it is unique (used only once) within the entire year.

I do already have an Excel file with the ranges so want to ensure:

  1. the syntax as-is would check the first two ranges
  2. How would I modify it to add each additional range? An example would be great!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!