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.

Linking Sheets

JF87
JF87 ✭
edited 12/09/19 inArchived 2017 Posts

I am trying to link two sheets.

The main sheet contains all my essential information, however one column has a list of drop down options.

If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet.

E.g: If in sheet 1, monthly payments are selected from the drop down menu, I want the name of this client to be shown in sheet 2.

Is this possible?

Tags:
· Share on Facebook Share on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Smart sheets does not currently have this capability.

    · Share on Facebook Share on Twitter
  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi

    Mike is right about doing it with cell linking (as far as I can think?) It might be possible using Datamesh but depends on the detail?

    However I have what I think is a simple and better suggestion.....

    Why not create a Report that shows all the Columns of Customer data you wish to see with the query that you only want to see Rows of data where "Monthly payments" is selected?

    Easier than Cell linking and will pick up automatically?

    Hope that helps?

    RichardR

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

Categories

If you hover over the data point, you should be able to grab the button on the right and click and drag it up and down.<\/p>
\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106720,"type":"question","name":"Percentage complete based on Y or N for six categories.","excerpt":"Hello I am trying to develop a formula that would provide percentage complete triggering on Y for each category. So, in short, if one Y is seen, display 18, if two Y's are seen, display 36, if three Y's are seen, display 54, if four Y's are seen, display 72, if five Y's are seen, display 90, and if six Y's are seen,…","categoryID":322,"dateInserted":"2023-06-21T18:24:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T12:12:35+00:00","insertUserID":155082,"insertUser":{"userID":155082,"name":"Cristian","url":"https:\/\/community.smartsheet.com\/profile\/Cristian","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcKDnyq8FmYjuhOFCk_LYZQ2zWK_KI0waOp6i093w=s96-c","dateLastActive":"2023-06-21T20:04:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T12:52:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":28,"score":null,"hot":3374811417,"url":"https:\/\/community.smartsheet.com\/discussion\/106720\/percentage-complete-based-on-y-or-n-for-six-categories","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106720\/percentage-complete-based-on-y-or-n-for-six-categories","format":"Rich","lastPost":{"discussionID":106720,"commentID":381703,"name":"Re: Percentage complete based on Y or N for six categories.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381703#Comment_381703","dateInserted":"2023-06-22T12:12:35+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T12:52:32+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-22T10:16:30+00:00","dateAnswered":"2023-06-21T19:37:55+00:00","acceptedAnswers":[{"commentID":381599,"body":"

If all rows are next to each other, you can use<\/p>

=MAX(COUNTIFS(TestOne@row:TestSix@row, @cell = \"Y\") * 18, 100)<\/p>


<\/p>

If they are not next to each other, you will need to \"add\" your IFs together instead of nesting them.<\/p>

=MAX(IF(TestOne@row = \"Y\", 18, 0) + IF(TestTwo@row = \"Y\", 18, 0) + IF(TestThree@row = \"Y\", 18, 0) + .................., 100)<\/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":106725,"type":"question","name":"Start\/stop buttons for timekeeping?","excerpt":"Hello! I am curious to know if anyone has a solution for stop\/start buttons to record team members' time toward projects in Smartsheet outside of Resource Management. This is for a small team without access to any premium apps. When a new project is set up, it is added to a master Project List sheet, and manually added to…","categoryID":343,"dateInserted":"2023-06-21T19:22:38+00:00","dateUpdated":"2023-06-21T19:27:04+00:00","dateLastComment":"2023-06-22T09:15:46+00:00","insertUserID":126351,"insertUser":{"userID":126351,"name":"Julie Fortney","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Fortney","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZje4WgcMyQ!en9eZ1QFHfo!MFtz_rjuwYj","dateLastActive":"2023-06-21T21:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"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-22T12:09:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":32,"score":null,"hot":3374804904,"url":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","format":"Rich","tagIDs":[468,553],"lastPost":{"discussionID":106725,"commentID":381687,"name":"Re: Start\/stop buttons for timekeeping?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381687#Comment_381687","dateInserted":"2023-06-22T09:15:46+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-22T12:09:58+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-21T21:40:12+00:00","dateAnswered":"2023-06-21T21:18:20+00:00","acceptedAnswers":[{"commentID":381638,"body":"

@Julie Fortney<\/a> <\/p>

Happy to help!<\/p>

This is the one I was thinking about. It's been some time since I played around with it, so let me know what you think after you've tested it.<\/p>

\n \n https:\/\/trackingtime.co\/time-tracking-for-smartsheet\n <\/a>\n<\/div>

✅Remember! <\/strong>Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up\/Awesome or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[{"tagID":468,"urlcode":"resource-management","name":"Resource Management"},{"tagID":553,"urlcode":"timekeeping","name":"timekeeping"}]}],"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

  • Is there a way to arrange data in a Metric Widget?

    On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think…

  • Percentage complete based on Y or N for six categories.

    Hello I am trying to develop a formula that would provide percentage complete triggering on Y for each category. So, in short, if one Y is seen, display 18, if two Y's are seen, display 36, if three Y's are seen, display 54, if four Y's are seen, display 72, if five Y's are seen, display 90, and if six Y's are seen,…

  • Start/stop buttons for timekeeping?

    Hello! I am curious to know if anyone has a solution for stop/start buttons to record team members' time toward projects in Smartsheet outside of Resource Management. This is for a small team without access to any premium apps. When a new project is set up, it is added to a master Project List sheet, and manually added to…