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!

Thanks

Syed

Find more posts tagged with

Formulas

functionality

Sheet Summary

Accepted answers

Syed Mohd Muhafzal

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

Andrée Starå

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!

All comments

Syed Mohd Muhafzal

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

Andrée Starå

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.