Can't get fields to map to lookup because of case sensitivity it seems. Is this intended for DataTable? If so, there should at least be an option to look for case sensitivity or not.
Are you able to provide screenshots for reference and more context? What formula(s) are you using? Some functions are case sensitive while others are not.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
@Paul Newcome I was using a DataTable connection so no formulas. I was using email as the unique identifier. The emails in the DataTable file are similar to "Mueller.Samuel@" and the emails in my sheet that was connected to the table were "mueller.samuel@" (because Smartsheet is lowercase). I came to this conclusion because the one record that did match had a lower-case email address in the DataTable file.
My use case is using a colleague list (colleague, leader, department, etc.) as a DataTable so I can bring in colleague leader to my target sheet (connected through DataTable lookup mode).
How do you enable multi-tier blueprints in control center? Do you have to create a new program first with it enabled, or can you enable the multi-tiered option on existing programs? Thanks,
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.