Problem with % format in a cell

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 (%)

Screen Shot 2021-08-02 at 7.04.58 PM.png

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

Screen Shot 2021-08-02 at 7.04.18 PM.png

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

Screen Shot 2021-08-02 at 7.04.28 PM.png

The cell stubbornly stays in decimal format.


Any ideas?

Best Answer

  • StevenBlackburnMBA
    StevenBlackburnMBA ✭✭✭✭✭
    Answer ✓

    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.

    Certifications:

    -Smartsheet 2023 Core Product Certification

    -Smartsheet 2023 System Administrator Certification

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!