Report not refreshing daily

NikkiOno
NikkiOno ✭✭✭
inSmartsheet Basics

I created a report from one of my sheets and the report was inaccurate when my boss looked at it at 10:00am MT this morning. He called me so I got on around 10:38 and hit refresh on my end and then the report was accurate. Why is this? All the data on the actual smartsheet was showing correct for him but the report itself was not matching the smartsheet. He said he hit refresh a bunch of times on his end but it still didn't update until i logged on and hit refresh.

· Share on Facebook Share on Twitter

Answers

Categories

The individual URLs will not change. They are tied to the Sheet ID which is hard set to that sheet regardless of location.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":265,"urlcode":"reports","name":"Reports"}]},{"discussionID":112251,"type":"question","name":"Compressing based on a column label different row data points in one cell","excerpt":"Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams. Both sheets can be linked through the interrelation they have, although the teams sheet have multiple times the department across rows (E-G:…","snippet":"Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams.…","categoryID":321,"dateInserted":"2023-10-27T12:05:54+00:00","dateUpdated":null,"dateLastComment":"2023-10-27T16:03:56+00:00","insertUserID":163137,"insertUser":{"userID":163137,"name":"Adrià Termes","title":"Intelligent Automation","url":"https:\/\/community.smartsheet.com\/profile\/Adri%C3%A0%20Termes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T16:00:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":113581,"lastUser":{"userID":113581,"name":"Matthew J McAteer","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20J%20McAteer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDFUs7dXyHo!7bFXOzNnVPw!fm5dCHPC2D9","dateLastActive":"2023-10-27T20:02:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":27,"score":null,"hot":3396832790,"url":"https:\/\/community.smartsheet.com\/discussion\/112251\/compressing-based-on-a-column-label-different-row-data-points-in-one-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112251\/compressing-based-on-a-column-label-different-row-data-points-in-one-cell","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":112251,"commentID":402038,"name":"Re: Compressing based on a column label different row data points in one cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402038#Comment_402038","dateInserted":"2023-10-27T16:03:56+00:00","insertUserID":113581,"insertUser":{"userID":113581,"name":"Matthew J McAteer","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20J%20McAteer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDFUs7dXyHo!7bFXOzNnVPw!fm5dCHPC2D9","dateLastActive":"2023-10-27T20:02:26+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/QYFA2XRWG5PR\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T16:01:43+00:00","dateAnswered":"2023-10-27T13:27:29+00:00","acceptedAnswers":[{"commentID":402001,"body":"

Hi @Adrià Termes<\/a> <\/p>

You can do this using a cross sheet reference.<\/p>

=JOIN(COLLECT({TeamTeam}, {TeamDepartment}, Department@row), \", \")<\/p>

TeamTeam references the Team column on the Team sheet, and TeamDepartment references the Department column on the Team sheet.<\/p>

Hope this helps.<\/p>

Matthew<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":112256,"type":"question","name":"Dashboard Views","excerpt":"It would be helpful to know how many views a dashboard is getting to see if it's effective","snippet":"It would be helpful to know how many views a dashboard is getting to see if it's effective","categoryID":321,"dateInserted":"2023-10-27T13:16:00+00:00","dateUpdated":"2023-10-27T14:23:56+00:00","dateLastComment":"2023-10-27T14:24:23+00:00","insertUserID":153592,"insertUser":{"userID":153592,"name":"nancy.mina","url":"https:\/\/community.smartsheet.com\/profile\/nancy.mina","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WTjeHghqMDQ!hHtd4ZRALXo!6Fyi9bnhkuz","dateLastActive":"2023-10-27T14:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-10-27T16:19:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":18,"score":1,"hot":3396831323,"url":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112256\/dashboard-views","format":"Rich","lastPost":{"discussionID":112256,"commentID":402018,"name":"Re: Dashboard Views","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402018#Comment_402018","dateInserted":"2023-10-27T14:24:23+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-10-27T16:19:28+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T14:24:11+00:00","dateAnswered":"2023-10-27T13:38:24+00:00","acceptedAnswers":[{"commentID":402006,"body":"

Hey @nancy.mina<\/a> <\/p>

If you're either the Owner or the Admin of a Dashboard on a Business or Enterprise plan, you can see Views by going to the Activity Log<\/strong> of the Dashboard (File > Activity Log).<\/p>

Here you can add a Date Range and filter by the Views action:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Can you clarify if this resolves your current request or if you had more specifics to your Idea?<\/p>

Thanks!<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":1},{"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&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":5206,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Moving Reports and Source Sheets to a new folder under existing Workspace

    I want to create a new subfolder under my existing Workspace that already contains Source sheets for each individual with their corresponding Reports. I want to do this because we are adding new company Divisions to the same Workspace. If I do this, will each already existing person's report still have the same URL? The…

  • Compressing based on a column label different row data points in one cell

    Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams. Both sheets can be linked through the interrelation they have, although the teams sheet have multiple times the department across rows (E-G:…

  • Dashboard Views

    It would be helpful to know how many views a dashboard is getting to see if it's effective

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video