Is it possible to use rollup to pull the sum of values from two different fields (both in the same view) into a single field in a second view?
I’m designing a teambuilding exercise app. It tracks exercise efforts from various teams, based on A) non-walking activities and B) Walking.
In the main view, one field uses various formulae to convert different types of exercise into their “step count” equivalent. For example, 30 minutes of playing basketball is worth 5000 steps (not really). The second field only requires a number input by the participant, based on a pedometer reading. In the end, both fields need to be summed together to show total steps taken by each participant. The expectation is that participants will record steps (from walking) and step equivalents (from non-walking activities).
Thanks in advance.