We would love to see functionality improvement where you can Edit Cell value to be equal another cell or formula calculating value from 2 cells or an option to calculate ROW to be driven from another row by right clicking on ROW and calculate, also add option to calculate cell itself by right clicking cell and ability to reference another cell/row.
Example case use would be to calculate bill of material in the table where for every vault we would need 20 bolts in which case we could create a calculate function in model builder not only calculating columns but also rows/cells by defining the row/column position.
Not entirely sure I follow, but have you looked into Attribute Rules (specifically, "Calculation"-style rules)? They can do a lot of automatic calculations for you in your tables.
It would be nice to have option to run calculate tool similar to excel where B2 = (B1+6)*2
Currently we have calculate collumn but no easy way to calculate row utilizing values in other rows or calculating one cell value utilizing other cells values.
For persistent calculations, you can store the value in a field using Attribute Rules (as Vince mentioned) or synthesize it on demand using the Pop-up Configuration. For one-time calculations, select the rows you want then run Calculate Field on the field (right-click on the field header in the attribute table for a shortcut).
That said, it would be very handy if you could right-click on individual values in either the attribute table or attribute pane to quickly select that record and launch the field calculator in one step.
Yeah, that is essentially an idea to allow users to click on the cell and calculate it to equal another cell or customize formula.
@Miralem_Zeljo, you clarified that this ideas is specifically to:
allow users to click on the cell and calculate it to equal another cell or customize formula.
Are you asking for the ability to store a persistent calculation for a single field value in a single row in a table? If so, could you share a use case for this so I can better understand what a feature like this might look like? I'd like to understand what you are trying to achieve by having the value of a field in one row operate differently than the same field value in other rows in the table.
As many have pointed out, Attribute Rules allow you to achieve the desired end result, but not in the way it seems you're requesting. Rules are part of the table schema and can be configured to evaluate on all rows in the table, or on rows of a specific subtype, but not on the field value of a single row without some undesirable workarounds.
It appears to be a fundamental data function in Excel, allowing for automatic calculations from one cell to another within the same dataset or a different one. This feature is highly useful, as it enables real-time updates and the ability to apply the same formula across a range of cells when needed by simple copy/paste.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.