# Score Formula

Options
edited 12/09/19

I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%.

I think is should be something like If score >100%,100%

but am not sure what the entire formula should be.

Tags:

• ✭✭✭✭✭✭
edited 12/28/18
Options

Hi Learle,

The numbers have to be formatted like 1 (for 100%) 0,5 or 0.5 (for 50%, depending on your region) for percent.

Try this.

=IF(Score@row >= 1; 1)

The same version but with the below changes for your and others convenience.

=IF(Score@row >= 1, 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

I would suggest using the "else" portion of the IF statement as well in case the score is less than or equal to 100%. Something along the lines of...

=IF(Score@row >= 1, 1, Score@row)

• ✭✭✭✭✭✭
Options

Paul,

Yes, that's a must. Thanks!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

No worries. I often forget to plug that part in and then get frustrated when my formulas aren't working the way they are supposed to. Hahaha

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!