Check a box when a list of names containing duplicate names contains the first occurance of a name
I am looking for a checkbox formula or another callout that will look at a list of project names and return a flag or check or another identification of the first occurance of each project name in the list. I am trying to get an accurate count of the number of jobs in that list. The list is small at this point, only 2 project names but will grow. I have entered auto number and duplicate callout columns, but am drawing a blank on where to go from there to get just the first occurance to check.
Answers
-
Hey @lrmerlino88886
Checking my understanding to make sure I'm giving you the formula you're looking for - you are expecting only 2 checkmarks in your dataset since you currently only have 2 separate projects. If I understood incorrectly, let me know.
Try this
=IF(COUNTIFS([Project Name]:[Project Name], [Project Name]@row, Auto:Auto, @cell<=Auto@row)=1, 1)
This should work as long as you are not rearranging the rows once they are created. If you do need to rearrange the rows then another helper column will be needed.
Will this work for you?
Kelly
-
Maybe, I will be able to check it out today and see if it works. Rows will not be rearranged once entered, however there may be more in the future. Only 2 at this point and time.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 477 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!