Skip to main content

Rollup field based on value in other (changing) field

  • July 11, 2022
  • 1 reply
  • 22 views

Hello!

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?

Thanks!
Dennis

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

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?)