Calculate ROW or Cell Similar to Excel

[MiralemZeljo1]

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.

[VinceE]

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.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/an-overview-of-attribute-ru... 

[MiralemZeljo1]

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.

[DavidSolari]

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.

[MiralemZeljo1]

Yeah, that is essentially an idea to allow users to click on the cell and calculate it to equal another cell or customize formula.