I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats.
I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a cell.format string to make it appear as $1,234.56
My best guess, based on the thin documentation I have found was ",,,,,,,,,,,13,2,1,2,," It isn't clear whether the decimalCount field needs to be set if the numberFormat is set. Either way, I have been unsuccessful in getting the value to format to anything resembling US currency.