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.

Tabs on smartsheet

Eddie Valentine ✭

06/05/15 edited 12/09/19 inArchived 2015 Posts

I probably know the answer to this, but is there a way to create tabs on one Smartsheet document? I am uploaded an Excel workbook with about 30-40 tabs on it. I am afraid that I will have to create 30-40 individual smartsheet documents.

Thank you.

Tags:

0 ·

Comments

SashaR ✭

06/08/15

Smartsheet does not have the workbook structure you are referring to and will only import the first sheet in an Excel file. After importing the 30-40 sheets, you could add them to a workspace on your home tab so that they are all organized in a single location.

Here is another thread that talks about something similar:https://community.smartsheet.com/discussion/replicating-multiple-worksheets-excel

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Hi @Elayne Smith<\/a>,<\/p>

The formula for this would be:<\/p>

=SUMIF(Project:Project, \"A\", [Grand Total]:[Grand Total])<\/p>

\n \n $\"image.png\"$ <\/img><\/a>\n <\/div>\n<\/div>\n

Hope this helps - any issues etc. then just post! 😊<\/span><\/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":106990,"type":"question","name":"JOIN COLLECT for Checkboxes","excerpt":"Hello All, Is there a way to collect information using a JOIN COLLECT formula? Column 2 is Name Column 3 thru 5 ASL. Columns 6 thru 8 is are the names I want to populate based on the checkboxes (ASL). Column 3 can have two checkboxes versus 1. Ultimately I would like all checkboxes that are checked to populate names in…","snippet":"Hello All, Is there a way to collect information using a JOIN COLLECT formula? Column 2 is Name Column 3 thru 5 ASL. Columns 6 thru 8 is are the names I want to populate based on…","categoryID":322,"dateInserted":"2023-06-28T02:32:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T12:51:39+00:00","insertUserID":162875,"insertUser":{"userID":162875,"name":"hello1030","url":"https:\/\/community.smartsheet.com\/profile\/hello1030","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-06-28T13:09:04+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":162875,"lastUser":{"userID":162875,"name":"hello1030","url":"https:\/\/community.smartsheet.com\/profile\/hello1030","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-06-28T13:09:04+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":21,"score":null,"hot":3375878655,"url":"https:\/\/community.smartsheet.com\/discussion\/106990\/join-collect-for-checkboxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106990\/join-collect-for-checkboxes","format":"Rich","lastPost":{"discussionID":106990,"commentID":382809,"name":"Re: JOIN COLLECT for Checkboxes","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382809#Comment_382809","dateInserted":"2023-06-28T12:51:39+00:00","insertUserID":162875,"insertUser":{"userID":162875,"name":"hello1030","url":"https:\/\/community.smartsheet.com\/profile\/hello1030","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nH14DQG3YON84.png","dateLastActive":"2023-06-28T13:09:04+00:00","banned":0,"punished":0,"private":true,"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-28T12:51:52+00:00","dateAnswered":"2023-06-28T08:50:42+00:00","acceptedAnswers":[{"commentID":382755,"body":"

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

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

Try something like this. (I've guessed what your formula would look like, but you'd have to update the column names to match yours)<\/p>

=JOIN(COLLECT([COLUMN2]:[COLUMN2], [COLUMN2]:[COLUMN2], 1, [COLUMN3]:[COLUMN3], \"Support\"), CHAR(10))<\/p>

Did that work\/help? <\/p>

There were a lot of errors in the formula, but it was mainly the brackets { is used for cross-sheet formulas, and you have to close the [ ] square brackets around a column name that doesn't only have one piece of text, and then the structure wasn't correct.<\/em><\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

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":[]}],"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":[]}">