Fill schedule column based on data from other column

[LyleHardin]

Is there a way to fill in a cell of a Revit schedule based on data from another cell?

For instance I am totaling MEP Fab parts ducts and elbows. I want a cell to say ELBOW if the LENGTH is 0" and STRAIGHT PIPE if the length is greater than 0".

Using the family or type name doesn't cut it.

[stever66 · Accepted solution]

That should be doable.

Go to your schedule, hit the "Edit Fields" button on the properties, and select the button that looks like "fx" in italics.  That's the calculated field button.  It will make a new calculated value. 

Give it a name, make it a text forumla, and use something like:

 =IF (Length > 0", “STRAIGHT PIPE”, “ELBOW”)

Here are some formula examples:

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

[LyleHardin]

Thanks.

This makes sense and I think it will work if I can just deal with those pesky "inconsistent units".

[stever66]

Did you figure it out?  If not, Where are you getting the length from?  Is it actually a length parameter in the family?  Or is it a text parameter?