I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries as numbers and not text because it will sum the amounts properly, but the report summary total on the column loses its currency formatting. Outside of changing user behavior (ha!), I am trying to create an automation that will give me a daily summary of the bad ones so I can change them.
Using the condition "does not contain" a period doesn't work (the bad ones 99% of the time are just a round number ($500 vs. $500.00). I assume that's because contains works with text and not numbers. I would also assume kluging a helper checkbox column with a contains formula onto my sheet would have the same limitation.
Any suggestions for an automation that flags these?
