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
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 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!