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

Opening an Australian Standard document from Intertek Inform (SAI Global)
Having problem opening a file downloaded from https://au.i2.saiglobal.com/ in Revu BlueBeam. Below is the error: "There is a problem with this protected document. It may be damaged. Please contact the publisher for a clean file." Currently using Revu Complete 21.5. Greatly appreciated if someone can help one this.
Tools for each window instead of sharing 1 tool palette for all windows open
When you have a document open and split so you have (2) windows, is there a way for the tools to display with each window so you don't have to go all the way across the screen to get to the 1 windows tools?
Grouping Items - Tool Chests
I want to group all WF Beams so when I click the beam for a take off it, has a pulldown to select the size. Can this be done?
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?