Score Formula

learle73571

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.

Andrée Starå

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

Paul Newcome

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)

Andrée Starå

Paul,

Yes, that's a must. Thanks!

Paul Newcome

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