Hi all,
I'm currently using a form for a health challenge type event at work. I have created a step calculator where people choose an activity (pulled from a SharePoint list) and then the number of minutes that they did the activity, and it calculates their steps for them. The problem is that it's in a repeating table (I also tried a repeating section) and when they insert a new line and choose another type of activity, the steps take in the first line change as well.
Is there any way that I can make the Steps Taken formula apply to each row independently?
This is the formula I'm using > Time * Steps_x0020_per_x0020_minute_x00[Title = Activity]
The SharePoint list has the Activity and a corresponding # of steps per minute.
Thanks in advance!
*Update: It seems to choose the activity that is alphabetically closest to A and uses those steps per minute across the board.