I have two Smartsheets: Config and Labeling. Both Smartsheets have Document #'s in them. The Config Smartsheet has multiple Document #'s in each row, in different columns, while the Labeling Smartsheet has one Document # in each row, all in one column. Both Smartsheets also have a Status column with the same dropdown options.
What I want to do is to connect the two Status columns, so if someone changes a status in the Labeling Smartsheet, the subsequent status in the Config Smartsheet changes automatically. This would be done by matching the Document # fields in each Smartsheet (so the status fields will connect if the Document #'s in each Smartsheet are the same for that row).
The issue I am facing is that the Config Smartsheet has multiple Document #'s per row, so I cannot do a straight 1:1 match. To help mitigate this issue, I created a Helper Column in the Config Smartsheet that joins all of the Document #'s present in each row to one cell (each Document # is separated by a comma).
The formula that I am trying to create in the Config Smartsheet Status column will look through the Document #'s in the Config Smartsheet Helper Column, and, if one of the Document #'s in that column matches a Document # in the Labeling Smartsheet, create a Status connection for those particular rows.
Any suggestions on how to do this would be greatly appreciated.