Requesting help with syntax of formula with multiple ranges
Chris Hallo
✭✭✭✭
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:
- the syntax as-is would check the first two ranges
- How would I modify it to add each additional range? An example would be great!
Answers
-
Hi your formula in A1 will not check if the role are uniques entries for the year.
Replacing 'OR' with 'AND' will help identify if there are duplicates within ranges.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!