UPDATE: Is there a way to ignore case in a unique identifier
UPDATE:
I figured out something about my query below - not all of the doi's on the source and target sheets have the same case (some lower case, some upper). I think this is my issue, which presents a new problem.
Is there a way tell smartsheet to ignore case? Or a formula to change case? I'm running into issues where my Unique Identifier is the result of a formula (which it can't be to be able to assign in data shuttle - I've had to copy the result into another column) - and now it's not matching the case.
Bah.
ASIDE: Is there a group of smartsheet folks who work with publication data that I can commiserate with / learn from?
Thank you!
Meredith
_____________________________________________________________________________________________
Hi all,
I'm trying to upload data to my sheet using data shuttle - which I have plenty of experience with. The column that I'm using as a unique identifier to merge data is a digital object identifier (doi).. I'm trying to merge publication dates and open access determinations into my sheet.
Some of these identifiers have a lot of characters in common - even though they are different numbers - like these:
I noticed that not all of the corresponding data for the above doi's uploaded to my sheet. I'm wondering if data shuttle looked at the first 18 or so characters and said, 'nope, those are the same numbers'.
I'd like to be able to use these numbers to import relevant data about the publication, but data from about 80 rows (of about 480) did not merge using these identifiers. I don't want to copy them manually every time I update my database.
Anyone have similar issues and maybe a workaround?
Thank you!
Meredith
Meredith Rhodes, PhD
ClinicalTrials.gov Specialist
UW School of Medicine & Public Health
UW Clinical Trials Institute
mkrhodes@clinicaltrials.wisc.edu
Answers
-
UPDATE: Looks like there are differences in capitalization in the unique identifier between the source sheet and the target sheet.
Is there a way to tell smartsheet to ignore case?
So many variables...
Thank you!
Meredith
Meredith Rhodes, PhD
ClinicalTrials.gov Specialist
UW School of Medicine & Public Health
UW Clinical Trials Institute
mkrhodes@clinicaltrials.wisc.edu
-
OK - I think I figured my own problem out.
I'll run make sure my identifiers are lower case with the =LOWER(@row) formula - and move this result over to my source sheet via data shuttle so it's not a formula there. Let me run this idea through the mill.
Meredith Rhodes, PhD
ClinicalTrials.gov Specialist
UW School of Medicine & Public Health
UW Clinical Trials Institute
mkrhodes@clinicaltrials.wisc.edu
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!