Score Formula

12/28/18 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.

Popular Tags:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 12/28/18

    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([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!

    Best,

    Andrée Starå

    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.

  • Paul NewcomePaul 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([email protected] >= 1, 1, [email protected])

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Paul,

    Yes, that's a must. Thanks!

    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.

  • Paul NewcomePaul 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

Sign In or Register to comment.