[paulfitz]

The motivation for calling Grist a spreadsheet is that it has formulas, and cell values get updated automatically when something they depend on gets updated. Agree there is scope for misunderstanding here, maybe there's a better word? [Grist employee]

[_v7gu]

You might want to look into calculated columns

[PurpleRamen]

This is normally called a database-app.