Percentage formatting with API

Jeremy RENAUDIN

Hello,

I'm trying to automate the modification of multiple spreadsheets with the API, and I'm bringing a detailed formula to my columns. The displayed value is a percentage so I'm bringing a value between 0 and 1, but I would like to directly format the column in percentage.

I've observed on an extract after setting manually the column that I've:

"displayValue": "95%"
"value": 0.949367088607595

Does that mean I need to set the value I'm displaying? As I'm calculating it, that looks to be two loops, one to apply the formula to my cell, then one to rewrite the result as a percentage which looks unconvenient.

Is there a way to set-up directly the column as percentage?

Thanks a lot,

Jérémy

Genevieve P.

Hi @Jeremy RENAUDIN

You'll want to set the format of the cell to be percentage, see: https://smartsheet.redoc.ly/#section/API-Basics/Formatting

This list doesn't specifically call out the numerical format of percent, but I found another discussion on StackOverflow that details an example, see: Filling in an allocation % column and have it display nicely

In this example they used:

'format': ',,,,,,,,,,,,,,3,'

Cheers,

Genevieve

Genevieve P.

Hi @Jeremy RENAUDIN

You'll want to set the format of the cell to be percentage, see: https://smartsheet.redoc.ly/#section/API-Basics/Formatting

This list doesn't specifically call out the numerical format of percent, but I found another discussion on StackOverflow that details an example, see: Filling in an allocation % column and have it display nicely

In this example they used:

'format': ',,,,,,,,,,,,,,3,'

Cheers,

Genevieve

Jeremy RENAUDIN

It worked, thanks a lot for redirecting me there!

Have a good day,

Jérémy