Estimating
Public Group
Public Group
Active a week ago
Estimating could include material take-offs for simple quantities or complex pricing. Whether you... View more
Public Group
Custom column formula error message
-
Custom column formula error message
Posted by Chris Riley on May 23, 2024 at 11:35 amStumped on this message. Anybody tell me what Bluebeam is trying to tell me? I have other formulas in my custom columns, and have never encountered this.
David Cutler replied 2 years, 1 month ago 7 Members · 14 Replies -
14 Replies
-
Points: 30,641Rank: UC2 Brainery Advanced Brown Belt II

I know you have to have the parameters listed in the order of operations, but it looks like you already have that correct. What happens when you delete them and start over? I’ve had to do that from time to time.
I’ve also seen some weird things in the latest update. Legends not reporting, text editing in a custom column. Could be a bug messing with several functions.
-
Points: 19,382Rank: UC2 Brainery Advanced Blue Belt IIII

the dreaded Excel #Value error
-
-
Points: 19,382Rank: UC2 Brainery Advanced Blue Belt IIII

Does it matter that one is Text and one is a Formula?
-
Points: 1,248Rank: UC2 Brainery Yellow Belt

Doesn’t seem to matter. I first created it as a text and was changing it to formula. I deleted it and then added it again as a formula and still get the same error.
-
-
Points: 17,066Rank: UC2 Brainery Advanced Blue Belt II

I think I may have come across something like this in the past – it was something to do with already having referred to the column in another formula i.e. you can’t refer to the same custom column twice. Well I think that was the issue – it was quite a while ago when I tried to use the formulas in Revu!
-
Points: 35,120Rank: UC2 Brainery Red Belt

That sounds as if it would be incredibly limiting @Vince – and probably very frustrating!
-
Points: 17,066Rank: UC2 Brainery Advanced Blue Belt II

I gave up on using the formulas in Revu when creating my first setup – that was for measuring roof timbers.
-
Points: 19,382Rank: UC2 Brainery Advanced Blue Belt IIII

they are pretty limiting
-
-
-
Points: 1,248Rank: UC2 Brainery Yellow Belt

Yeah this would be incredibly limiting. If you can’t re-use a variable then the variable list would get very long.
-
-
Points: 8,900Rank: UC2 Brainery Purple Belt III

I may be under complicating this, but I did three custom columns, one for input and the other two referencing the value, it seems to work ok on my end.
-
Points: 1,248Rank: UC2 Brainery Yellow Belt

Some how I had 2 columns that had the same name, neither of which I was using for the particular formula I was writing, but I deleted one and I think it may have solved my problem. Have not had time to do some more in depth testing, so stay tuned…
-
Points: 35,120Rank: UC2 Brainery Red Belt

I can see having multiple columns with the same name happening very easily – especially if you are using different column layouts in different profiles…
-
-
-
Points: 251Rank: UC2 Brainery Newbie

I am having the same issue. Lots of bugs popping up all of the sudden.
-
Points: 30,641Rank: UC2 Brainery Advanced Brown Belt II

I was curious if maybe you needed to bump the PLLength parameter above the PLWeight parameter in the list to match the order in the formula. I know you have to have the list of parameters in the order of operations or they don’t work. It has to figure out one thing before it can insert that information into the next step.
Log in to reply.