LINKING CELLS AND PERCENTAGE

C. Srinidhi Ragunathan · 11/05/18

Hi.

I have a master Smartsheet and multiple other sheets which are linked to the smart sheet.

While linking the % complete for each project onto the master sheet, the numbers get saved as a decimal/fraction (0.50) and not in % (50%) format. This happens even though the % complete in the primary sheets are in % format.

Can someone please tell what the issue is ?

Thank you

Andrée Starå · 11/05/18

Hi,

You have to change the formatting on the cells to percentage format. (4th icon from the right in the toolbar)

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome · 11/05/18

^^^ The cells on the master sheet are what Andree is referring to.

NSanchez90676 · 01/31/20

Hi Andrée,

I have the same issue as Srinidhi, but I am using a join to get information from other smartsheet files; I actived the percentage icon and nothing happens; if there is no directly solution, I was thinking if I can apply the TEXT formula from Excel, but I couldn't find the equivalent for smartsheet.

=TEXT( value , format text)

=TEXT( A3/100 , "#%" )

Can you please provide me this formula if exist and I can add it to my JOIN formula.

Have a Great Friday!!!

Neil R Sanchez.

Stanford Health Care

Andrée Starå · 02/09/20

@NSanchez90676

Did you get it working or do you still need help?

LINKING CELLS AND PERCENTAGE

Comments

Categories