It needs to be a Multi Select
The below is what came up in the columns:
Address Column: 200 E Eckerson Rd New City NY 10956
City: New City NY
Seems like we're almost there..
Can you please let me know how to include only the City?
This is what it should look like:
Hi @Leibel Shuchat
Where am I wrong?
Could be you have extra spaces somewhere?
Thank you @Leibel Shuchat for your help,
I'll definetly come back here in the future, right now I found a way to manually include all the Cities, but this is a great formula!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.