Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to show a percentage in a cell with text mixed with formula

Options

Hi, I have a percentage complete cell which is working correctly when the following formula is used and the cell is set to show as a percentage:

Formula: =SUM([Column5]24, [Column5]29, [Column5]33) / 3

Result: 25%

However if I add text to the front of the formula, the result changes back to an integer:

Formula: ="Progress (Supervisor) " + SUM([Column5]24, [Column5]29, [Column5]33) / 3

Result: Progress (Supervisor) 0.248868893729418

Is there any way I can specify the output of the formula to show as a percentage?

Thanks in Advance.

Comments

  • Schiff A.
    Schiff A. Employee
    Options

    Hi Sandra_Shedden,

    You can effectively have the result of the formula display as a percentage by rounding to two decimal places, multiplying by 100, and adding a percent symbol as a string to the end.



    In your example, you could use this formula: ="Progress (Supervisor) " + (ROUND(SUM([Column5]24, [Column5]29, [Column5]33) / 3, 2) * 100) + "%"

     

    Let us know if you have any questions.



    Thanks,

    Schiff

    Smartsheet Support

This discussion has been closed.