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