I was trying to avoid the need to iterate/loop over all the rows by just using some formulas to create some “virtual” fields and let the summation capabilities of reports take care of selectively adding things up. However, I was supposing that you h...

I’m new to Airtable and just stumbled across this question so this suggestion might not work, but in Smartsheet or even Excel you can have computed columns, so for instance you could have a table that has 3 “imputed value” columns for Products A, B, ...

New year, new voice making the same point. We’ve acquired Smartsheet because it’s FedRAMPed and provides much the same capability as Airtable (I guess technically Airtable is the copycat), but SmartSheet’s management and support seem to be a shamble...