Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
How do I add a picture on Sights
How can I add a picture to my Sights. Your sample below appears to allow this function, but I cannot figure it out.
Comments
-
Chuck - In the current release of Sights that only way to get a picture to appear is to insert an image into a cell and then have that cell displayed in a report. The image will then appear as part of the report as in the above example. This is not the most elegant solution so their are improvements on the way. On April 12th we will release an update so that you can use the Metric widget to link to a cell with an image. See example below. Soon we will also have an image widget that will allow you to upload an image directly to the widget without having to first place the image in a cell.
-
Chuck Muirhead ✭✭✭✭✭
Thank you Scott!
I look forward to implementing the workaraond for now and wait for the updates
-
Chuck Muirhead ✭✭✭✭✭
As an FYI to anyone else looking at this. I created a report to pull in a picture I have in a cell on a client Sheet. Removed all columns and hid the primary column. Resized the image in the report (this is a must) and then added a report widget to show the image on my Sight dashboard. As Scott mentioned, this is not an elegant, but it is a workaraound. Outside of the example below, I will just wait until the update to do this on a mass scale. Since each dashboard would have a different picture (of another dashboard), I would have to create 90 reports of 1 picture for each dashboard.
Thanks again Scott, at least now I can show the team, what it will look like once we are able to add pictures via a widget.
Categories
Hi, <\/p>
I hope you're well and safe!<\/p>
Try something like this.<\/p>
=IF([Date Reported]@row <> \"//www.santa-greenland.com/community/discussion/4613/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/4613/\", NETDAYS([Date Reported]@row, TODAY()), NETDAYS([Date Reported]@row, [Resolution Date]@row)))<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic weekend!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109470,"type":"question","name":"Trying to get OR to work with Countifs","excerpt":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks! =COUNTIFS({CNC, CMM, and BL Request Sheet Need by date},…","snippet":"First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State =\"In Queue\" or \"In Process\". Current error I get is…","categoryID":322,"dateInserted":"2023-08-25T15:27:49+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T17:16:16+00:00","insertUserID":165685,"insertUser":{"userID":165685,"name":"Wade Herrin","title":"Cell Leader","url":"https:\/\/community.smartsheet.com\/profile\/Wade%20Herrin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Ztvd2bxcfH4!c6jdhwhyx7Q!hsgJTX6RzVB","dateLastActive":"2023-08-25T18:16:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3385962845,"url":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109470\/trying-to-get-or-to-work-with-countifs","format":"Rich","lastPost":{"discussionID":109470,"commentID":392637,"name":"Re: Trying to get OR to work with Countifs","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392637#Comment_392637","dateInserted":"2023-08-25T17:16:16+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T17:07:38+00:00","dateAnswered":"2023-08-25T17:07:32+00:00","acceptedAnswers":[{"commentID":392632,"body":" Nailed it, thank you!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":109468,"type":"question","name":"Compare duplicate rows, identify most recently added","excerpt":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank…","snippet":"I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date…","categoryID":322,"dateInserted":"2023-08-25T15:12:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:33:42+00:00","insertUserID":138358,"insertUser":{"userID":138358,"name":"Stefanie S.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Stefanie%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T15:56:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3385959358,"url":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109468\/compare-duplicate-rows-identify-most-recently-added","format":"Rich","lastPost":{"discussionID":109468,"commentID":392620,"name":"Re: Compare duplicate rows, identify most recently added","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392620#Comment_392620","dateInserted":"2023-08-25T16:33:42+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T18:56:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/VIINAL1P3WNF\/screenshot-2023-08-25-at-11-08-09-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-08-25 at 11.08.09 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:58:16+00:00","dateAnswered":"2023-08-25T15:52:39+00:00","acceptedAnswers":[{"commentID":392600,"body":" This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.<\/p> =IF(AND([Created]@row <> \"//www.santa-greenland.com/community/discussion/4613/\", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
