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

bcostlow

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

bcostlow

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

Lost mark-ups
I am having an issue where when I save, mark-ups just disappear before my eyes. I do a save after every sheet of mark-ups, and at random, every mark up I did just disappears. What is strange is that they still appear in the mark-up list, but that does me no good. I have tried exporting and reimporting the markups, doesn't…
Relocate Drawing Set Files?
Is it possible to relocate a drawing set from a laptop to a server? I have a large set with several revisions and would like to move it to a server to share to with others.
Perimeter Measurement
Perimeter measurement is an integral part of my work, however, is not available on my system (Bluebeam Revu x64 Basics). Is this correct and if so, what do I need to do to make this available. This is the only tool that I need (that is not available to me already) and I'm hoping that I do not have to upgrade my system to…
Storage location for toolboxes
Whe I add a new toolbox, I am prompted for a place to save it. The default location, at least mine, is in the Windows user area. Something like C:/users/(your name)/AppData/Roaming/Bluebeam software/Revu/21. In my office we share files on One Drive. Can a default storage location be set so we don't have to climb up and…
Global settings for Mark up
Hi, Need to find out how to do a Global or Default setting for changing the current Measurment tool from inches to mtrs and font size, color of infill etc. Currently we have to go for every single take off measurements from changing this from Feet to Meters and rest of font size , color of infill etc. there must be a short…
How to print markups outside the document area
Hi - new to the group. Confounded by this question. I am not able to print markups outside of the document area and the document. In print settings I am able to print either the document or the markups but when I click document and markups the markups are cut off at the document edge. I am making markups outside the…
Take offs
hello I'm new here. I am needing to use this program to find the square footage and the baseboard perimeter of a project that I'm bidding on and I have no idea how to add it to the app or how to make it work. Can somebody please help me?
markups cant be moved
I have some markups that cannot be moved oredited after I change the linetype to a linetype that I created in bluebeam. Anyone have any answeres as to why this may happen
Digital Signature limitations
This past weekend I was working with some fillable PDFs from the Department of the Army (United States). Bluebeam was able to open the PDFs just fine, but signing them caused Revu to crash on me and it would say something about the type of file being unsupported. I ended up just downloading Adobe to sign those specific…
Bluebeam Studio Capability
Hi all I've been asked by a client to recommend software to store all of the drawings in an organised manner, ideally with an interface that links to the General Arrangement Drawings [e.g. click on a room and all the drawings are listed]. What they are after is a simplistic BIM. Is this something Studio could do ?