Dashboards

1, Date:Date, AND(@cell >=…","categoryID":322,"dateInserted":"2021-11-23T15:06:03+00:00","dateUpdated":null,"dateLastComment":"2021-11-23T19:36:20+00:00","insertUserID":139648,"insertUser":{"userID":139648,"name":"Kyle Hicks","url":"https:\/\/community.smartsheet.com\/profile\/Kyle%20Hicks","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-03T16:02:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":72,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/85213\/sumifs-i-think","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/85213\/sumifs-i-think","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-12-06T14:33:01+00:00","dateAnswered":"2021-11-23T16:19:38+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":85088,"type":"question","name":"Pulling data from one sheet to another","excerpt":"I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, \"Overhead\", {Date}, IFERROR(MONTH(@cell), \"\") = 11) However, this formula is returning an improper total, it reads \"24\" when it should be…","categoryID":322,"dateInserted":"2021-11-18T16:04:00+00:00","dateUpdated":null,"dateLastComment":"2021-11-19T16:15:51+00:00","insertUserID":139648,"insertUser":{"userID":139648,"name":"Kyle Hicks","url":"https:\/\/community.smartsheet.com\/profile\/Kyle%20Hicks","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-03T16:02:46+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-08-27T07:46:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":173,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/85088\/pulling-data-from-one-sheet-to-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/85088\/pulling-data-from-one-sheet-to-another","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-11-19T12:10:56+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":18826,"type":"discussion","name":"Attaching a file to a sights widget","excerpt":"I have attempted to link a file (from onedrive) to a widget in sights and have also attempted to upload from googledocs. When the user clicks on the link or file, the system takes them onedrive saying access denied or to googledocs online. How do i attach a word doc so it is not connected to onedrive or googledocs? ","categoryID":321,"dateInserted":"2018-02-05T05:49:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-11-19T00:40:05+00:00","insertUserID":10758,"insertUser":{"userID":10758,"name":"Sally Osborne","url":"https:\/\/community.smartsheet.com\/profile\/Sally%20Osborne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-16T22:21:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":52641,"lastUser":{"userID":52641,"name":"EcoPartnering","url":"https:\/\/community.smartsheet.com\/profile\/EcoPartnering","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-19T00:39:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":327,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/18826\/attaching-a-file-to-a-sights-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18826\/attaching-a-file-to-a-sights-widget","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Jira gadget import to dashboard?
Hello, Is there a way to iframe or embedd an Jira gadget into Smartsheet Dashboard? For example, we'd like to import the sprint velocity gadget into Smartsheet instead of creating it from Smartsheet datasheet.
If/Then type formula
I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. The only issue is that some of the percentages based upon the goals are beyond 100%.…
Moving multiple widgets in a dashboard
I would like to move multiple widgets at one time on a dashboard. Is there a way to do this?
Color item no longer representing on dashboard
I have a sheet where a person sets project status. They can choose Green, Yellow, Red, Grey or Blue. Since Smartsheet cannot handle 5 color lights, I do the following. The person can set G, Y, R or Grey directly. If their project is launched (blue), then instead they check a box indicating it it has launched. I have a…
Customer Facing Dashboard
你好,我们已经开始使用内容on customer facing software implementation and want to leverage the use of dashboards as a customer 'hub'. Does anyone have any examples of customer facing dashboards that you use specifically for software implementation that you would be willing to share (feel free to block out…
Resizing Sight To Eliminate Blank Space
Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leaves some space. That means the height of the frame has to be large enough to span the…
Looking for an automated way to Pareto Dashboard data in a Chart Widget from a Report
I have large datasets with various records that have spikes and some that have only a few occurrences. Right now I have things structured in a main sheet where all the data is entered, then a summary sheet with the potential values (which need to be manually maintained to some degree) with a VLOOKUP formula to count the…
SUMIFS I think?
I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is: =SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >=…
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
Attaching a file to a sights widget
I have attempted to link a file (from onedrive) to a widget in sights and have also attempted to upload from googledocs. When the user clicks on the link or file, the system takes them onedrive saying access denied or to googledocs online. How do i attach a word doc so it is not connected to onedrive or googledocs?

Dashboards

Discussion List