cell.format currency settings

Galen Work

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.

Alejandra

Hi gwork,

Since formatting can change at any time, there's a note that says you can get the current format table from the server:

You could also just set the desired formatting for one cell and then look at the sheet again with ?include=format

I hope this helps!

dave-inden

It looks like this question was also asked on Stack Overflow and an answer that should work was given there. You can find the post here:

https://stackoverflow.com/questions/57973834/smartsheet-api-cell-format-of-currency

Alejandra

Thanks Dave!