The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Is it possible to create a roll-up based on the value of another field? Conditional roll-ups won’t do the trick, because I’d like to the value to be ‘variable’, and not fixed.
Is this possible with a formula within the aggregate field? Or any other suggestions? I guess the needed functionality looks a lot like “sum-if” from Excel?
Hm, when I face this issue I usually end up making a new formula field where I apply the conditions within that formula, and then roll up on that instead
Any chance that could work for you here?
(Oh also, could I perhaps get screenshots of what you’re trying to rollup and how to see if I can figure out a workaround?)