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.

    Doug McLean replied 2 weeks, 5 days ago 6 Members · 11 Replies
  • 11 Replies
  • Troy DeGroot

    Organizer
    May 23, 2024 at 11:58 am
    Points: 21,476
    Rank: UC2 Brainery Brown Belt I UC2 Brainery Brown Belt I

    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: 13,133
      Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

      the dreaded Excel #Value error

  • Doug McLean

    Member
    May 23, 2024 at 12:52 pm
    Points: 13,133
    Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

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

    • Chris Riley

      Member
      May 23, 2024 at 1:40 pm
      Points: 1,199
      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: 12,281
    Rank: UC2 Brainery Blue Belt II UC2 Brainery 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!

    • David Cutler

      Member
      May 23, 2024 at 2:18 pm
      Points: 24,231
      Rank: UC2 Brainery Brown Belt IIII UC2 Brainery Brown Belt IIII

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

      • Vince

        Member
        May 23, 2024 at 3:10 pm
        Points: 12,281
        Rank: UC2 Brainery Blue Belt II UC2 Brainery Blue Belt II

        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: 13,133
          Rank: UC2 Brainery Blue Belt III UC2 Brainery Blue Belt III

          they are pretty limiting

    • Chris Riley

      Member
      May 23, 2024 at 2:34 pm
      Points: 1,199
      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: 6,731
    Rank: UC2 Brainery Purple Belt I UC2 Brainery Purple Belt I

    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,199
      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…

Log in to reply.