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
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
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.