Column Search

Karrie Davis
Karrie Davis Overachievers
edited 12/09/19 inSmartsheet Basics

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.

lpm.PNG

lpm 2.PNG

Tags:
· Share on Facebook Share on Twitter

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Kari,

    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])

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    thinkspi.com

    · Share on Facebook Share on Twitter
  • Karrie Davis
    Karrie Davis Overachievers

    Hi Andre,

    I just shared two sheets with you. Please let me know if you need anything else

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Thanks!

    I'll take a look and get back to you soon!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter

Categories

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":"

Hi @moraki<\/a> <\/p>

There currently isn't a way to remove the Reply button or the reply-to email function for @mentions in Smartsheet. (Here's the Help Article on this functionality: Using @mentions in comments<\/a>)<\/p>

Please submit your feature request to the Product team by creating an Idea Post<\/strong> in the Smartsheet Product Feedback and Ideas topic<\/a> here in the Community. This will allow other users to vote on your enhancement idea!<\/p>

Cheers,<\/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":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106398,"type":"question","name":"Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","excerpt":"New user and new to the community. Trying to figure out if there's a way to send a multiple-row update request that allows the requestee to submit one row update at a time, save along the way, and\/or use the update request link multiple times vs. the requestee having to provide every row update before clicking submit.…","categoryID":321,"dateInserted":"2023-06-13T20:49:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T15:59:53+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T15:22:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-15T15:29:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"score":null,"hot":3373449573,"url":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106398\/is-there-a-way-to-send-a-multiple-row-update-request-that-allows-multiple-as-you-go-submissions","format":"Rich","tagIDs":[446],"lastPost":{"discussionID":106398,"commentID":380525,"name":"Re: Is there a way to send a multiple-row update request that allows multiple (as-you-go) submissions?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380525#Comment_380525","dateInserted":"2023-06-14T15:59:53+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-15T15:29:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T15:22:45+00:00","dateAnswered":"2023-06-13T22:19:44+00:00","acceptedAnswers":[{"commentID":380402,"body":"

Hi @mgreenwalt<\/a> <\/p>

I hope you're well and safe!<\/p>

Here's a possible workaround or workarounds <\/strong><\/p>