cell.format currency settings

Galen Work
Galen Work ✭✭
edited 12/09/19 in API & Developers

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.

Comments