Problem with % format in a cell

Todd Smelser

I have a cell in a summary sheet in which I am using a JOIN function simply to pull from another sheet.

The cell in that sheet properly displays the data in a percent format (%)

However the cell in my Summary sheet, displays the linked information as a decimal

I have clicked the cell and toggled the format button off and on (This usually refreshes the Column/Cell)

The cell stubbornly stays in decimal format.

Any ideas?

StevenBlackburnMBA

https://community.smartsheet.com/discussion/comment/300047#Comment_300047

I may be getting too simplistic here, but I am figuring you need to use the JOIN function? I typically just hyperlink the cell from another sheet and directly link it to that cell and lock it. That way, I get the number from the previous sheet updated to use in my reports and dashboards and lock it as a way of validating that data can't be manually changed.

I haven't used the JOIN function yet -- so not sure if you NEED it for something you are doing on that sheet was why I brought the other up.

Jasmine

On the Sheet Summary, for the field you would like in %... click on the 3 dots, under "Number Formatting" select "Percentage".

Todd Smelser

Thank you but I have tried that, and toggled it on and off, many times.

Brett Wyrick

@Todd Smelser What browser are you using? I recall this happening to people using Internet Explorer. Are you on Chrome or the new Microsoft Edge? Try it in another browser and tell me if you are seeing the same thing.

This is an odd one!

Andrée Starå

Hi @Todd Smelser

It's probably not working because the join formula changes it to text.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots and the formula? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Todd Smelser

Hi Andre,

This is a simple JOIN({Gantt 2021 Upgrade Range 6}) formula used to pull the contents of a cell from my Gantt into a Summary sheet. I was wondering if the formula itself was causing the format to be ignored.

I suppose I could set up a simple link to that cell.

StevenBlackburnMBA

https://community.smartsheet.com/discussion/comment/300047#Comment_300047

I may be getting too simplistic here, but I am figuring you need to use the JOIN function? I typically just hyperlink the cell from another sheet and directly link it to that cell and lock it. That way, I get the number from the previous sheet updated to use in my reports and dashboards and lock it as a way of validating that data can't be manually changed.

I haven't used the JOIN function yet -- so not sure if you NEED it for something you are doing on that sheet was why I brought the other up.

StevenBlackburnMBA

Just noticed you thought the same thing :)

Todd Smelser

Hi @StevenBlackburnMBA ,

I think you are right. I typically just put in the JOIN function reflexively but the link to cell would work just as well in this case and does preserve the % format.