When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard widget which could be an easy solution.
I do this all the time. Just use the format painter on the data formatting within the metrics widget. This will pull through the formatting of the cell being referenced by that widget to include conditional formatting rules within the source sheet.
Paul, thank you so much. When I couldn't figure out how to do conditional formatting on a widget, I contacted Smartsheet support who told me that this feature was not available and I should submit the suggestion for future implementation. It works perfectly!
2023-06-01T19:19:21.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":107133,"type":"idea","name":"Replying to Comment via email","excerpt":"When I send a comment using @ functionality from a Sheet, I would like reply comments to come into the Sheet. In other words, the recipient should be able to simply use \"reply\" via Outlook to send a reply, rather than needing to log into the Sheet to reply. I have used SS for at least 3 years, and that was always standard…","snippet":"When I send a comment using @ functionality from a Sheet, I would like reply comments to come into the Sheet. In other words, the recipient should be able to simply use \"reply\"…","categoryID":349,"dateInserted":"2023-06-30T12:37:38+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T14:40:16+00:00","insertUserID":163041,"insertUser":{"userID":163041,"name":"Cynthia FUrlong","title":"Head of Sales Execution","url":"https:\/\/community.smartsheet.com\/profile\/Cynthia%20FUrlong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T12:37:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-30T20:11:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":1,"hot":3376265574,"url":"https:\/\/community.smartsheet.com\/discussion\/107133\/replying-to-comment-via-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107133\/replying-to-comment-via-email","format":"Rich","tagIDs":[363,441],"lastPost":{"discussionID":107133,"commentID":383330,"name":"Re: Replying to Comment via email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383330#Comment_383330","dateInserted":"2023-06-30T14:40:16+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-30T20:11:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"}]},{"discussionID":107060,"type":"idea","name":"Tabbing through \"pages\" in form","excerpt":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other information being collected.","snippet":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other…","categoryID":349,"dateInserted":"2023-06-28T21:15:07+00:00","dateUpdated":"2023-06-28T21:15:23+00:00","dateLastComment":"2023-06-29T17:52:36+00:00","insertUserID":80376,"insertUser":{"userID":80376,"name":"brandi.meyer80376","url":"https:\/\/community.smartsheet.com\/profile\/brandi.meyer80376","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T18:10:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":80376,"lastUserID":160129,"lastUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T19:41:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":53,"score":5,"hot":3376050163,"url":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":107060,"commentID":383171,"name":"Re: Tabbing through \"pages\" in form","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383171#Comment_383171","dateInserted":"2023-06-29T17:52:36+00:00","insertUserID":160129,"insertUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T19:41:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":5}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106980,"type":"idea","name":"Ability to Find & Replace text in Formulas","excerpt":"Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…","snippet":"Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find &…","categoryID":349,"dateInserted":"2023-06-27T21:44:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T00:09:35+00:00","insertUserID":160498,"insertUser":{"userID":160498,"name":"svenu","title":"Sowmya","url":"https:\/\/community.smartsheet.com\/profile\/svenu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DCMMVCYWQVDW\/n8MOHGOMZQ316.jpg","dateLastActive":"2023-06-30T01:49:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":163029,"lastUser":{"userID":163029,"name":"Shonnify","title":"Payroll Tax Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shonnify","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3dDW_y9sleY!!OlNA9rJUxAN","dateLastActive":"2023-06-30T00:17:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":2,"hot":3375987266,"url":"https:\/\/community.smartsheet.com\/discussion\/106980\/ability-to-find-replace-text-in-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106980\/ability-to-find-replace-text-in-formulas","format":"Rich","tagIDs":[254,363],"lastPost":{"discussionID":106980,"commentID":383244,"name":"Re: Ability to Find & Replace text in Formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383244#Comment_383244","dateInserted":"2023-06-30T00:09:35+00:00","insertUserID":163029,"insertUser":{"userID":163029,"name":"Shonnify","title":"Payroll Tax Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shonnify","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3dDW_y9sleY!!OlNA9rJUxAN","dateLastActive":"2023-06-30T00:17:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-01T19%3A19%3A21%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":143,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">