Discussions – General Questions – UChapter2

Using Formulas In Custom Columns

General Questions

Using Formulas In Custom Columns

Posted by Vince 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?

Thanks

Vince replied 2 years, 9 months ago 2 Members · 2 Replies
2 Replies

David Cutler

Member
March 25, 2022 at 7:58 am

Points: 26,754
Rank: UC2 Brainery Advanced Brown Belt

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
  
  Member
  March 25, 2022 at 10:39 am
  
  Points: 13,687
  Rank: UC2 Brainery Blue Belt III
  
  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

Log in to reply.