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


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!



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!