Forums
Forums >> Revit Building >> Technical Support >> Reset Yes/No parameter in schedules to neutral
|
|
active
Joined: Thu, Feb 21, 2008
3 Posts No Rating |
It's pretty hard to read a schedule full of yes's & no's. Is there a way to reset the yes/no value back to neutral so that only the yes's appear and the other cells are empty??When you first create a schedule with yes/no parameters the value is neutral with neither "yes" or "no" displaying in a given cell (ie. blank). If you tick a cell and set it's value to "yes", and then decide later that value needs to be changed, the only option appears to be "no" instead of also being able to reset back to neutral. I'd hate to think that in order to be consistant I have to change all the neutral values to "no"?? which then becomes a real mess to read on a large schedule (I'm working with hundreds of doors and windows !!)I've tried holding the usual keys (ctrl / shift etc) and clicking on the tick box but it keeps returning back to yes or no.A solution would be great, thanks.
|
This user is offline |
|
![](images/spacer.gif) |
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
![3.5 Stars: 391 Votes](/images/stars_3.5.gif) |
Y/N is just that- either Y or N. But why not be creative and add a calculated field? if(y/nParameter, "Y", " " ) As a text field. Then just turn off your y/n column.
Edited on: Fri, Nov 27, 2009 at 8:38:10 AM
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Thu, Feb 21, 2008
3 Posts No Rating |
Thanks heaps for that !! I had actually created these parameters as project parameters, so I plugged your formula into a calculated value and it works a treat. Cheers.
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Fri, May 5, 2006
262 Posts
![3.5 Stars: 7 Votes](/images/stars_3.5.gif) |
I would also like to know if there was a way to do this without the workaound. The yes/no parameter works great, and if you don;t mess anythign up (by accidentaly clicking a yes box), it will remain blank. There should be a way to reset this to blank. But then again, it IS Revit! ![Smile](/images/smiles/smile.gif)
-----------------------------------
**Using Revit Architecture 2009, 2011, and 2012** |
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Fri, Jan 16, 2009
3 Posts No Rating |
This thread is old but when I put "if(y/nParameter, "Y", " " )" into a calculated Value I get "The Following Is Not A Valid Schedule Field) Thanks, I am certainly the one at fault.....just ask my wife!
|
This user is offline |
|
![](images/spacer.gif) |
active
Joined: Fri, May 5, 2006
262 Posts
![3.5 Stars: 7 Votes](/images/stars_3.5.gif) |
:-)
You took that too literal. You need to replace "y/nParamter" with the actual name of the y/n parameter in your schedule. For example, based on the photo you attached, if "THRESHOLD" were your y/n parameter, then you would use the formula: if(THRESHOLD, "Y", " ").
Good luck.
-----------------------------------
**Using Revit Architecture 2009, 2011, and 2012** |
This user is offline |
|
![](images/spacer.gif) |
![](images/spacer.gif) |
Similar Threads |
ADDING WALL HEIGHT PARAMETER TO WALL SCHEDULES |
Revit Building >> Technical Support
|
Mon, Aug 30, 2010 at 12:57:36 PM
|
4
|
Reset Linework? |
Revit Building >> Technical Support
|
Tue, Sep 12, 2006 at 7:45:03 PM
|
2
|
Phase Filters in Schedules |
General Discussion >> Revit Project Management
|
Sat, Mar 20, 2010 at 9:15:43 AM
|
1
|
Reset Instance Parameters |
Revit Building >> Technical Support
|
Wed, Apr 24, 2013 at 3:25:59 AM
|
0
|
display order command and reset visibility graphic setting |
Revit Building >> Technical Support
|
Tue, Jul 31, 2007 at 2:51:00 PM
|
0
|
![](images/spacer.gif) |
|
Site Stats
Members: | 2022391 | Objects: | 22974 | Forum Posts: | 152201 | Job Listings: | 3 |
|