# Sheet List of specified values **URL:** \ **Category:** Revit\ **Tags:** views\ **Created:** [June 29, 2018, 2:44pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244 "2018-06-29T14:44:29Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [June 29, 2018, 2:44pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/1 "2018-06-29T14:44:29Z")
Hi Everyone, maybe it’s a common question, but I couldn’t find any pertinent post on the forum. I’d like to create a specific Sheet List based on some Sheet Numbers the user gives to Dynamo. Is there a way of doing that? (The use will type the Sheet Number in the code block, or from Data types drop down list). Thanks for all your help! Carmine ---
**Author:** ![cescobido](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@cescobido](https://forum.dynamobim.com/u/cescobido)\ **Post date:** [June 29, 2018, 5:41pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/2 "2018-06-29T17:41:36Z")
Hi @carmine.lb, I might be able to help you with this, but could you tell me what you are trying to accomplish.? There are a number of way of give dynamo the numbers Excel Spread sheet, .csv files, or as you say manually typing in in a code block like so: {“A1-0001”,“A2-0001”}; ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/0/702d7af4bbcd4fb1f182e6444848219189113f1e.png) The way I usually accomplish this is by using an Excel spread sheet using the following nodes. **File Path** **File.FromPath** **Excel.ReadFromFile** ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/8/3827014619ecb824848ccc288f4a0315ef6f2f77.jpg) Cheers. Chris ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [June 29, 2018, 6:35pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/3 "2018-06-29T18:35:05Z")
Why not use Data-Shapes to give the user a list of ALL sheets and have the user select the ones they want? ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 2, 2018, 8:28am UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/4 "2018-07-02T08:28:19Z")
Hi … thank you so much for so many replies? I didn’t actually have problems exporting to a SPREADSHEET (in Excel)… What if I want that these sheets create a SHEET LIST (internal in Revit) ? That’s my problem… ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 2, 2018, 8:29am UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/5 "2018-07-02T08:29:16Z")
Yes, I thought of that… the user select the sheets with the ui.listview graph… but how could they put it in a SHEET List (internal in Revit, no export in Excel) ? ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [July 2, 2018, 2:12pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/6 "2018-07-02T14:12:44Z")
Create a project parameter (manually or through Dynamo) that will be used for custom sheet lists. Have the user select the sheets to be added to the new sheet list and have them specify a filter value (ex. “Permit Set - Mech”). Apply the parameter value to all the sheets selected and create a new sheet list schedule with a filter that matches the filter value. ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 2, 2018, 2:20pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/7 "2018-07-02T14:20:16Z")
I was thinking of something more elegant, without a “custom” parameter… I mean, if I had to fileter them out, the user can actually do it with some criterias… I was rather thinking, is there a way of including in this sheet list random sheets, that have not a parameter in common…?. With The data-shapes listview definition, the user choose a random set of sheets… how can he put them into a sheet list…? ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [July 2, 2018, 2:25pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/8 "2018-07-02T14:25:14Z")
You’re still bound by the rules of Revit. A sheet list is just a schedule of sheets. The only way to limit a sheet list is with a filter. You can use Dynamo to do all of this for you though. ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 2, 2018, 2:28pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/9 "2018-07-02T14:28:36Z")
Now I was thinking (how good is when mindstorming a problem :p) to override the problem I can select THOSE drawings from the entire list of sheet and apply a filter mask, potentially should work… I only got a question left: How to create a Sheet list from dynamo? I tried the View.Schedule create node but seem like doesn’t like sheet category… 😛 have you ever used that? ---
**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\ **Post date:** [July 2, 2018, 2:33pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/10 "2018-07-02T14:33:00Z")
You would likely have to use Python to create your sheet list. [http://www.revitapidocs.com/2018/76fa4e7d-9201-b601-9924-0462e00cd883.htm](http://www.revitapidocs.com/2018/76fa4e7d-9201-b601-9924-0462e00cd883.htm) ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 2, 2018, 2:33pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/11 "2018-07-02T14:33:43Z")
Good tip, I’ll have a look a it! Thanks! ---
**Author:** ![cescobido](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@cescobido](https://forum.dynamobim.com/u/cescobido)\ **Post date:** [July 3, 2018, 7:10pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/12 "2018-07-03T19:10:49Z")
Hi @carmine.lb, I do not have access to dynamo on the weekend so I could not answer you back, but I’m still missing the point.? You are trying to create a sheet list for what reason.? printing/exporting or for drawing list to put on a sheet.? @Nick_Boyts suggested using Data-Shape nodes might be your answer if you just want the user to manually pick the sheets, but you could also do this within Revit to create your SheetSet. I usually use dynamo to automate redundant task which can be done programmatic. I’d like to give an example using your question as a bases below. When it comes to issuing drawings I would get a drawings list from Project Manager (PM) or a Team Lead (TL). This would be either a form of email, word or excel document. Now picking the sheet again in Revit to create a SheetSet is redundant because the list is already create I don’t want to do this again. I’d like to use dynamo to automate this process using excel to push the information back to Revit. In this case I use this node: (_spring nodes_) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/1/0184eee12c2e3ef551328f9926dad98e9deda951.png) The first example I posted was just an example to read the data from excel (Sheet list) using this data I filter the sheet using the sheet number. Once I get all the Sheet I need to link it into the node above in “views”. This will create the SheetSet for you without the user manually picking each Sheet again in Revit. view = View Elements setName = name of the set (string or text) Overwrite = If the set name exist do you want to overwrite (True or False) I hope this is what you are looking for.? Kind Regards Chris ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 4, 2018, 9:03am UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/13 "2018-07-04T09:03:22Z")
I need a Sheet List to add it to a some drawings… As I said before, sometimes the user doesn’t have a particular criteria for this list, I tried but sometimes it’s impossible to filter them out without excluding some of the needed sheets… The fastest way should be UI.Listview definition, then what? How should I translate from the set to a List? Thanks! ---
**Author:** ![cescobido](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@cescobido](https://forum.dynamobim.com/u/cescobido)\ **Post date:** [July 4, 2018, 5:56pm UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/14 "2018-07-04T17:56:59Z")
@carmine.lb I think your problem is more of a work flow issue than a dynamo problem. The example I have been giving you may help with dynamo for automation of a curtain task. But unfortunately it cannot solve human issue. 🙂 So I think I understand now; you want a drawing list as Schedule to be place on a drawing. I think the simplest approach works much better than a complex approach. I believe someone on this trend already mention, either add a new parameter on the sheet which you can filter or use an existing parameter not used for anything that can be filtered. This solution will only work if you are ok with having the schedule constantly changing on every submission. Personally I would use a text parameter, this way I can have two or more submission at the same time and contain sheet which belonging to two or more submission on a separate sheet schedule. By using dynamo and example I have posted you can push the information from excel to Revit. Example of Excel spread sheet below: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/2/c2e0e633d4a9ff162605dda4b90d5c04763dacf7.png) Apologies I cannot solve work flow issues, but I can suggest something that might work for you. You just need to figure out the method you want to use. ---
**Author:** ![carmine.lb](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carmine.lb](https://forum.dynamobim.com/u/carmine.lb)\ **Post date:** [July 5, 2018, 8:27am UTC](https://forum.dynamobim.com/t/sheet-list-of-specified-values/23244/15 "2018-07-05T08:27:12Z")
dear cescobido, thanks for the highlights and explanations. As you said, it is a workflow problem I’m trying to resolve, based on my users’ experience. I was wondering if there is already something useful in Dynamo, rather than using a parameter (we already use lots of parameters in projects, I don’t want users to be confused more than normal). I should find a concise way of filter the sheets using the parameter they’re using now. Thanks!