Is there a way to create a formula for an individual cell in a Coda Table?
Gold | 24% | $
If my table has the asset name: gold
The percent of my investment funds that i want to allocate to it
then how can create the “$” column so that each row multiplies my “Total Investment Funds” (which is in another table) by the “%” column?
Each Asset name has a different correlating percentage so i cannot create one formula for the entire column.
I’m having a hard time envisioning what your tables all look like without examples, but it sounds like you’re not really asking for per-cell formulas–it’s just that that’s one way of reaching your goal. But
Coda by design doesn’t care about “cells” and has no idea what cells are; Coda’s smallest unit is a row.
Even if it did support individual cells, using them is more-often-than-not a symptom of unsustainable table design
There’s usually a more elegant solution to be had in table relations.