Using the salesforce connector workflow I wish to filter where team member name contains 'Fred', Bill', "florence'
I see that I cannot create separate OR conditions as AND appears the only option.
So can I achieve the same result another way?
I may be misunderstanding the question, but would this work? Here I assume the row name is [Row Name] but you can change that to what the actual row name is to test.
=IF(OR([Row Name]@row = "Fred", [Row Name]@row = "Bill", [Row Name]@row = "Florence"), true, false)
sorry. my question is perhaps not clear. I am using a workflow connector from Salesforce and trying to limit the rows returned by the query to Smartsheet. I want to filter on a field (Team Member Name) and return rows to Smartsheet where the contents of the salesforce field match one of a number of names.
Ah, I understand.
Can you select "Includes on or More" and then select which names you want to pull across?
There is a 'contains' option but you cannot then select names. Instead you are offered a text field. I can enter one name fine but all my attempts to multiple name using formats like ('Fred', Jim', 'Alice') are returning syntax type errors. I have tried other things like 'Jim' OR 'Fred' etc
Perhaps it is just limited. I can't even create a separate filter option for each name as they are all 'AND''d together with no option to use the OR boolean function
I think it has to do with the Field Type in Salesforce. If it is a Picklist, you might be able to pick options. If it is a text field, you might be limited.
I would reach out to your Smartsheet rep for help.
Right now we have the Business Plan, but I'm considering moving to the Enterprise Plan only to get access to the Work Apps feature. Looking for some real user reviews to determine if it would be worth it. What do you like and not like about the feature?
Hi, I'm running into an issue as described in this post, but with Data Shuttle: Timestamps only match selected date format when clicked on — Smartsheet Community I configured a Data Shuttle workflow to replace all rows when a .csv file is attached to the target sheet. The attachment has a Timestamp column with a Date and…
I've created a Dynamic view sheet for a couple of my partners and have added them as shared users but it doesn't seem like Smartsheet sends a notification once they are added as a shared user. How do they get access to the sheet and does it require they create a smartsheet account?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.