topic Re: Schedule Formula in Revit Architecture Forum

Schedule Formula

DrakeCanyonArchitecture — Sat, 17 Jul 2021 17:14:53 GMT

In the schedule below, I would like to use the FM d column on the right to convert that information to a lumber size. In other words, if the value equals 0' - 5 1/2" it will display as 2x6, or 0' - 3 1/2" would display 2x4. These are AGACAD schedules btw, so maybe there is another easier way that I'm not seeing. I just can't find the fields that might display this information. It seems like there should be a way to write a formula that basically says some thing like If (FM d = 0' 5 1/2", 2x6, If (FM d = 0' 3 1/2", 2x4, 2x8))). We do have some 2x8 walls. Any thoughts on this? I've thought about renaming the families, but would rather not change things like that if possible.

Re: Schedule Formula

barthbradley — Sat, 17 Jul 2021 17:41:15 GMT

Use another column that uses a Text Parameter Type with formula = if(FM d = 0' 5 1/2", "2x6", If (FM d = 0' 3 1/2", "2x4", "2x8"))). Put quotes (e.g. " ") around values.

Re: Schedule Formula

DrakeCanyonArchitecture — Sat, 17 Jul 2021 17:42:40 GMT

Awesome, that worked, thank you! Revit made me take one of the parenthesis off at the end, 2 instead of 3.