Combine data from multiple columns, unless data is the same
Hello Smartsheet Community!
We have (2) sets of columns of data that pull in data from (2) other sheets for Ship Dates, Tracking, Order Numbers, etc. Sometimes both sets of columns will be populated sometimes just one column will be populated.
We are currently using the JOIN function to combine the data from a set of (2) columns into a single column, but when both columns are populated, its bunching the data from both columns together (screenshot below of the ship date + tracking columns)
How would we go about asking Smartsheet to look at both columns, bring in the data, but if the data is the same, only bring in one set of the data?
Thank you in advance for the help!
Help Article Resources
Check out the Formula Handbook template!