Using Formulas In Custom Columns

  • Using Formulas In Custom Columns

    Posted by Vince French on March 25, 2022 at 1:20 am

    Morning All

    I’ve just been trying to play about with these but keep getting a “An item with the same key has already been added” message – am I right in thinking that the Length column can only be referenced by just one new custom column?


    Vince French replied 1 year, 6 months ago 2 Members · 2 Replies
  • 2 Replies
  • David Cutler

    March 25, 2022 at 7:58 am
    Points: 20,528
    Rank: UC2 Brainery Brown Belt UC2 Brainery Advanced Brown Belt Rank

    I’m not sure I’m understanding your question @Vince – I made a custom column with a formula of “Length * Length”. I then made a second custom column with a formula of “Length * Length * Length” with no issues.

    Note that the “Length” appears to default to the “Quantity” value so that when I measured an area my column displayed “Area * Area”.

    I’m guessing perhaps you are working with something more complicated though…

    • Vince French

      March 25, 2022 at 10:39 am
      Points: 10,507
      Rank: UC2 Brainery Blue Belt UC2 Brainery Blue Belt Rank

      Hi @David Cutler – I am trying to add some formulas with angles in them. The first one which is linked to the length works fine but as if I try to add another one then I get the above message.

      However, I’ve now gone down the PQ route which is working rather well for my roofing (carpentry) take-off sheet.

Log in to reply.