Smartsheet Sheet Summary - Not Able to Show % in Sheet Summary using Join formula

Syed Mohd Muhafzal · 05/14/20

Hi All,

Hope you all are safe and well.

Question : Is it possible to show a percentage (%) in my sheet summary by using a =JOIN formula? I would like to use this so I can use the metrics widget in the dashboard.

I have created a formula to show value (in percentage) whenever a checkbox is checked. This is working.

Then I created a sheet summary with =JOIN formula as below. This is so my sheet summary will always display whatever is showing on the master sheet above - when the box is checked.

I have selected the Number Formatting to Percentage. However it is still showing as below. I have refreshed, saved and close the sheet but it is still the same.

My dashboard needs percentage :(

Thank you in advance and hope you all are having an awesome day so far!

Thanks

Syed

Syed Mohd Muhafzal · 05/14/20

Hi - this is solved. I just updated the =JOIN to =VALUE(JOIN(range:range)). Should have figured this out - duh!

Andrée Starå · 05/14/20

Hi Syed,

Easy to miss!

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Syed Mohd Muhafzal · 05/14/20