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.
✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Not if you use the TODAY function in the sheet(s). They have to be "activated".
Please have a look at my post below with a method I developed to update the sheet(s) daily.
More info:
Hi everyone,<\/p>
Happy New Year!<\/p>
I hope you're well and safe!<\/p>
I've developed a way to use the newly released Record a date <\/strong>feature to update sheets with today's date automatically without the need to open it or similar.<\/p>
1.<\/strong> Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.<\/p>
2.<\/strong> You'd then use an Automation Workflow as described below.<\/p>
Trigger:<\/strong> When a date is reached<\/p>
Every day starting on 2021-01-06 (today or earlier)<\/em><\/p>
02:00 (select the time that makes the most sense for the process)<\/em><\/p>
✅Remember!了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
✅Remember!了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
✅Remember!了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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":"