Conditional Formatting in Schedule - If/Then

Conditional Formatting in Schedule - If/Then

biagioni-paulette
Contributor Contributor
1,113 Views
3 Replies
Message 1 of 4

Conditional Formatting in Schedule - If/Then

biagioni-paulette
Contributor
Contributor

Is there a way to create an if/then forumla in a schedule parameter? I have a door schedule with an existing parameter for a hardware package type. We have three "types" - 1, 2, and 3. I would like to create a new conditional if/then parameter: i.e. if Hardware package type = 1, then the new parameter would = 5, if hardware package type = 2, then the new parameter would = 10, if hardware package type = 3, then the new parameter would = 15. I think this is something Revit should be able to calculate, but I'm not quite sure how to go about doing so.

0 Likes
1,114 Views
3 Replies
Replies (3)
Message 2 of 4

lucdoucet_msdl
Advisor
Advisor

@biagioni-paulette 

 

The new values are called calculated values and the revit help link is as follows:

 

https://help.autodesk.com/view/RVT/2020/ENU/?guid=GUID-44EC6734-D36B-4083-8FCD-833B166D6C0A

 

A link at the bottom of this help article will also lead you to formulating numerical expressions with conditional statements.

 

Good luck

 

-Luc

0 Likes
Message 3 of 4

ToanDN
Consultant
Consultant
If you original hardware type is a number or an integer parameter then yes, your formula for the calculated parameter (number or integer): = hardware type * 5.

https://revitforum.org/showthread.php/1046-Revit-Formulas-for-quot-everyday-quot-usage
0 Likes
Message 4 of 4

barthbradley
Consultant
Consultant

Almost sounds like you are describing what we do via Key Schedules.

 

 

FWIW: 

 

 https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2016/EN...