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.

Multiple projects on one sheet

Carol Key
Carol Key ✭
edited 12/09/19 inArchived 2016 Posts

We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if you do, how do you get the data from them (budget, start/end date, etc) into reports and such?

Tags:
· Share on Facebook Share on Twitter

Comments

  • Sean
    Sean ✭

    One method we use is to have a default value in a hidden column that allows you to only report on specific rows accross multiple sheets. you can then narrow the report query paramaters using your date or resource fields.

    · Share on Facebook Share on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 04/22/16

    Carol,

    I think Sean's answer is the way to go.

    I used project codes in a column. I don't bother to hide them, usually.

    Did you get what you needed?

    Craig

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

I understand. Unfortunately, there is no other option that I see. One thing to make it easier for you to add the name is to have a helper column in the source sheet with a formula to identify duplicates. If there is a record with no duplicate (i.e., a new name added), you can get notified through a workflow and use that to add the name to your metric sheet.<\/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":106984,"type":"question","name":"Using Countif to count Often and Very Often,","excerpt":"however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS(\"Often\", @cell), NOT(HAS(\"Very\", @cell)))","snippet":"however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS(\"Often\", @cell), NOT(HAS(\"Very\",…","categoryID":322,"dateInserted":"2023-06-27T22:21:22+00:00","dateUpdated":"2023-06-27T22:25:38+00:00","dateLastComment":"2023-06-27T22:37:19+00:00","insertUserID":13941,"insertUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":13941,"lastUserID":13941,"lastUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3375811121,"url":"https:\/\/community.smartsheet.com\/discussion\/106984\/using-countif-to-count-often-and-very-often","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106984\/using-countif-to-count-often-and-very-often","format":"Rich","lastPost":{"discussionID":106984,"commentID":382723,"name":"Re: Using Countif to count Often and Very Often,","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382723#Comment_382723","dateInserted":"2023-06-27T22:37:19+00:00","insertUserID":13941,"insertUser":{"userID":13941,"name":"steinkj","title":"","url":"https:\/\/community.smartsheet.com\/profile\/steinkj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-04\/84\/c0\/n84c060f2d4e16db2de757af80ad4cdca.png","dateLastActive":"2023-06-27T22:35:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T22:37:48+00:00","dateAnswered":"2023-06-27T22:37:19+00:00","acceptedAnswers":[{"commentID":382723,"body":"

Thank you, as always I was trying to make it too hard!!!!<\/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":106975,"type":"question","name":"Case sensitivity when using data mesh","excerpt":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…","snippet":"I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including…","categoryID":343,"dateInserted":"2023-06-27T19:39:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":114017,"lastUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3375793110,"url":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106975\/case-sensitivity-when-using-data-mesh","format":"Rich","lastPost":{"discussionID":106975,"commentID":382692,"name":"Re: Case sensitivity when using data mesh","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382692#Comment_382692","dateInserted":"2023-06-27T20:09:07+00:00","insertUserID":114017,"insertUser":{"userID":114017,"name":"Jacqueline Ennis","url":"https:\/\/community.smartsheet.com\/profile\/Jacqueline%20Ennis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZA0IOt6rrnETj3_ATzn0g7JjbJTEyOyIfrNKKb=s96-c","dateLastActive":"2023-06-27T20:08:06+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T20:09:23+00:00","dateAnswered":"2023-06-27T20:09:03+00:00","acceptedAnswers":[{"commentID":382691,"body":"

Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[]}">

Trending Posts

  • Orderable Charts

    Good morning, I've done several searches here but now I'm going in circles. I have a sheet with records of usage of certain scripts we have. Each row has the user name, the script they used and the time they saved by using each script. My goal is to create a dashboard with two bar charts: user name vs total time savings…

  • 通常使用条件统计计算和Often,

    however I can't get it to work the Often is also counting the Very Often: =COUNTIF([Tools & Resources (SE-2)]8:[Tools & Resources (SE-2)]12, HAS("Often", @cell), NOT(HAS("Very", @cell)))

  • Case sensitivity when using data mesh

    I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also…