Using a dropdown to pull duplicates
Hello,
I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO" I need to be alerted if they are entered in any other cell for that date. I can easily set up conditional formatting on the "Duplicates" row to catch attention. But I'm having issues setting up a formula to detect the duplicates. Here is my current formula which is in the "Duplicates" row. =COUNTIFS([General Attending]@row:[Neuro ICU Attending-DAYS]@row(HAS = [Faculty on PTO]@row))
I really hope a formula can be entered to search via Column name rather than having to enter each person's name within the formula because that will change frequently enough to be a time sink.
I'm also including a screenshot of my Smartsheet, just know it doesn't contain all of the columns.
Answers
-
It looks like you may just have a syntax issue. Try this...
=COUNTIFS([General Attending]@row:[Neuro ICU Attending-DAYS]@row, HAS([Faculty on PTO]@row, @cell))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!