Requesting help with syntax of formula with multiple ranges


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!