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.
The numbers have to be formatted like 1 (for 100%) 0,5 or 0.5 (for 50%, depending on your region) for percent.
=IF([email protected] >= 1; 1)
The same version but with the below changes for your and others convenience.
=IF([email protected] >= 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!
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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([email protected] >= 1, 1, [email protected])
Yes, that's a must. Thanks!
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