Smartsheet Column Removing and Adding Commas
Hello,
I seem to be having a situation in a column formula where it is adding and removing a comma every other hour. My Formula for this column is basic:
=IFERROR(IF(Markets@row = "", "", Month@row + "_" + Markets@row + "_" + Model@row), "")
The UID Column is the one in question. Markets@row is a multi select drop down, Model is a single drop down
Month, Markets, Model and the UID columns are being sent via datamesh to another sheet however they are sending double the amount of Markets because the UID's keep changing by removing and adding commas. Here is a snippet of the cell history.
Has anyone else seen something like this? My formula is not doing anything with or referencing to remove the comma so I do not know why it is going back and forth. Here is the result in the target sheet. Each Market should have 9 rows, however for ones with a comma in the Market are sending 18 rows over with the , being the difference between them
Answers
-
Update!!!!
I found a solution that is working. I just made a separate column (=Markets@row) that does not remove the "," so I replaced the UID with that field and changed by datamesh to make that the lookup value.
I just found it weird for my example and screenshots that the Cell link was pulling in Alexandria, LA but my formula was removing the "," all together. Going to chalk it up to something with the multi drop down select messing with it but was curious if anyone else has run into this issue.
