I'm looking to create a total data sheet that gives me the total spreadsheet for the current week, next week and previous week, from data from another worksheet. The problem that I have is that the dates are the column names, does anyone have any suggestions on how to accomplish this. Currently I just highlight the columns that to use and the people but is there another way to do this so I'm not creating new formulas every week.
Would it work if we structured the sheet with the dates on the rows instead of the columns?
Can you show more of the sheets so I can see the structure?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])
I generally follow something very similar to Andree's suggestion. Depending on the amount of data and the use of that data, I will set it up two different ways.
.
1. Make everything a date column, put the date in the top row, then reference row 1 in all of my formulas.
.
2. (Most often used for me) is to use three additional rows. One for day, one for month, one for year. I can then reference the cell in the same column on the appropriate row for whatever portion of the date I am trying to use as my criteria.
.
Some of my other sheets are also broken down by week number and year.
You will have to get an admin of Teams to allow the Smartsheet for Teams app in the admin console of Teams.<\/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":[]},{"discussionID":106358,"type":"question","name":"Remove Reply in Smartsheet Button from Comment Notification","excerpt":"Hello, I use the Comments of the Sheet to communicate with other people regarding the Requests we have in the Sheet. The comment notification that is sent automatically when a user has mentioned another user in a comment is very useful. However, I would like to remove the \"Reply in Smartsheet\" button that is shown at the…","categoryID":321,"dateInserted":"2023-06-13T10:55:28+00:00","dateUpdated":"2023-06-13T10:55:37+00:00","dateLastComment":"2023-06-15T12:45:57+00:00","insertUserID":160277,"insertUser":{"userID":160277,"name":"moraki","url":"https:\/\/community.smartsheet.com\/profile\/moraki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T11:23:42+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-06-15T17:22:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":39,"score":null,"hot":3373489285,"url":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106358\/remove-reply-in-smartsheet-button-from-comment-notification","format":"Rich","tagIDs":[219,441,510],"lastPost":{"discussionID":106358,"commentID":380749,"name":"Re: Remove Reply in Smartsheet Button from Comment Notification","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380749#Comment_380749","dateInserted":"2023-06-15T12:45:57+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-15T17:22:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"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\/YS8LARGCN51D\/comment.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"comment.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T12:27:37+00:00","dateAnswered":"2023-06-14T12:14:50+00:00","acceptedAnswers":[{"commentID":380442,"body":"