Custom column formula error message

  • Custom column formula error message

    Posted by Chris Riley on May 23, 2024 at 11:35 am

    Stumped 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 months, 1 week ago 7 Members · 14 Replies
  • 14 Replies
  • Troy DeGroot

    Organizer
    May 23, 2024 at 11:58 am
    Points: 23,744
    Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown Belt III

    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.

    • Doug McLean

      Member
      May 23, 2024 at 12:51 pm
      Points: 15,212
      Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

      the dreaded Excel #Value error

  • Doug McLean

    Member
    May 23, 2024 at 12:52 pm
    Points: 15,212
    Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

    Does it matter that one is Text and one is a Formula?

    • Chris Riley

      Member
      May 23, 2024 at 1:40 pm
      Points: 1,248
      Rank: UC2 Brainery Yellow Belt UC2 Brainery Yellow Belt Rank

      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.

  • Vince

    Member
    May 23, 2024 at 1:43 pm
    Points: 13,687
    Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

    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!

    • David Cutler

      Member
      May 23, 2024 at 2:18 pm
      Points: 26,754
      Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

      That sounds as if it would be incredibly limiting @Vince – and probably very frustrating!

      • Vince

        Member
        May 23, 2024 at 3:10 pm
        Points: 13,687
        Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

        I gave up on using the formulas in Revu when creating my first setup – that was for measuring roof timbers.

        • Doug McLean

          Member
          May 28, 2024 at 10:50 am
          Points: 15,212
          Rank: UC2 Brainery Advanced Blue Belt UC2 Brainery Advanced Blue Belt Rank

          they are pretty limiting

    • Chris Riley

      Member
      May 23, 2024 at 2:34 pm
      Points: 1,248
      Rank: UC2 Brainery Yellow Belt UC2 Brainery Yellow Belt Rank

      Yeah this would be incredibly limiting. If you can’t re-use a variable then the variable list would get very long.

  • Isaac Harned

    Member
    May 28, 2024 at 8:20 am
    Points: 8,113
    Rank: UC2 Brainery Purple Belt III 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.

    • Chris Riley

      Member
      May 28, 2024 at 8:39 am
      Points: 1,248
      Rank: UC2 Brainery Yellow Belt UC2 Brainery Yellow Belt Rank

      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…

      • David Cutler

        Member
        October 10, 2024 at 7:10 am
        Points: 26,754
        Rank: UC2 Brainery Advanced Brown Belt UC2 Brainery Advanced Advanced Brown Belt Rank

        I can see having multiple columns with the same name happening very easily – especially if you are using different column layouts in different profiles…

  • Chris Brunner

    Member
    October 7, 2024 at 3:21 pm
    Points: 251
    Rank: UC2 Brainery Newbie UC2 Brainery Newbie Belt Rank

    I am having the same issue. Lots of bugs popping up all of the sudden.

  • Troy DeGroot

    Organizer
    October 7, 2024 at 4:29 pm
    Points: 23,744
    Rank: UC2 Brainery Brown Belt III UC2 Brainery Brown Belt III

    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.