If-then formulas for Custom Columns

Aaron Hopkins · 2025-02-27T19:53:26+00:00

There was an error rendering this rich post.

Hello, I'm pricing a job that has both LF measurements for wall base and Wall Area measurements for wall panels. I currently have a formula calculating Raw Material Cost (custom column) which is: Measurement * Material. I have multiple other columns building off this value to add various other data. (Mark-up on material, Fabrication Hrs, Installation Hrs, Total cost & Total sell for)

Q: Is there a way to have the formula calculating: Measurement * Material look first at the "Wall Area" column and if it the value is 0 then look at the "Measurement" column? [Open to other solutions]

Thank you.

Find more posts tagged with

Estimation

Custom Columns

Accepted answers

Brandon Costlow

Formulae are pretty limited at this time.

From the bluebeam support page on Custom Columns

Formulae can consist of the following elements:
Variables: Includes column names like Area, Count, Length, Measurement, Volume, and so on. Any new custom columns created will be added to this list
Constants: Includes the value of e, value of pi, and so on.
Functions: Includes acos, asin, atan, ceiling, cos, floor, ln, log, round, sin, sqrt, and tan.
Operators: Includes:Addition (+)Subtraction (-)Multiplication (*)Division (/)Exponential (^)Modulus (%)Negation (-)

All comments

Brandon Costlow

Formulae are pretty limited at this time.

From the bluebeam support page on Custom Columns

Formulae can consist of the following elements:
Variables: Includes column names like Area, Count, Length, Measurement, Volume, and so on. Any new custom columns created will be added to this list
Constants: Includes the value of e, value of pi, and so on.
Functions: Includes acos, asin, atan, ceiling, cos, floor, ln, log, round, sin, sqrt, and tan.
Operators: Includes:Addition (+)Subtraction (-)Multiplication (*)Division (/)Exponential (^)Modulus (%)Negation (-)

Aaron Hopkins

Thanks bcostlow, that's what I was thinking. Your statement technically answers my question (and technically correct is best correct ;) unfortunately, the problem remains.

Jes Stafford

Would it work if you included both area and measurement in your formula? …assuming one or the other would be zero.

(Wall Area + Measurement) * Material

Stu

I have the same problem and get the following error message when trying to put in (Wall Area + Measurement)

Any ideas?

Quick Links

Recently asked questions

Bluebeam and Procore
Do you know of an integration between Bluebeam and Procore that allows Bluebeam to mark up plans and sync to Procore? Thank you Vinnie Seattle WA
Callout Shape Options
Hi, is there a way to add an oval shape callout in Bluebeam? In my industry, we often use oval callouts to identify equipment, but currently, only rectangle, circle, triangle, and hexagon options are available. It would be great to have an oval shape option or the ability to adjust the circle dimensions to create an oval.…
Dimension extension lines TOO long
After my last update… When I add a Dimension to a pdf the extension lines are way to long. Sometimes putting them off the edge of the page. I have: set and checked scale checked dim line and text size any ideas….
Multiple Signatures
Is there a way to apply multiple digital signatures to a document without having to Save after each signature?
Are folks using Bluebeam to create dashboard for various project links/information?
If this is something that people are using is it possible to share some examples for inspiration?
About Studio Prime End of Life (EOL)
Studio Prime End of Life will be EOL, can you tell us in reference to the future roadmap? Studio Prime End of Life (EOL) effective December 31, 2025
Save before Checking In?
This is a simple question. When I've 'Checked Out' a document in my BB Studio Project and added mark-ups, does it automatically Save when I 'Check In'? Or should I click save first, and then Check In?
Graphics Issue & I can't see text
Has anyone experienced where I go to create a text box with a pointer and then when I'm selecting it I get a weird graphics issue, then when I start typing I can't see my text? Computer: Windows 11 version 24H2 Grahics: Nvidia RTX 4000 Bluebeam Version: Bluebeam Revu 21.5 Graphics Issue: Can't see text while typing Can see…
Can I filter sessions by my status?
I was hoping to find a way to filter sessions by "My Status", so I can quickly see those I have marked as "reviewing" or "finished", but I do not see that as an option in any of the dropdowns that are visible to me. Does anyone know if this is possible? Thanks in advance!
How to Track Project Issues
What is the best way to track project issues? I have issues that are emailed to me by my contractor customers and need some way to flag it and remember to follow up on it. I am having too many emails fall through the cracks and are not resolved in a timely manner.