I have 4 actions in an “Execute a sequence of actions” to add child rows when a new player is added which are “Add Strokes Row”, “Add Points Row”, “Delete Total Row”, and “Add Total Row”. The “Delete Total Row” has the following formula “Filter(“A_Flight_Scoring”, AND([Label] = “Total”, [_THISROW].[Team] = [Team], [_THISROW].[Game] = [Game]))” and the action is “Delete Row”. There is only 1 row for each team that contains “Total” in the Label column. However, when “Delete Total Row” action is run it deletes all the rows with the [_THISROW].[Team] = [Team] disregarding the [Label] = “Total”. It also seems intermittent. It appears that if I populate the spreadsheet with more than one player on the same team it seems to work. Each team is to have only one Total at the end of its section in the spreadsheet and needs to be at the bottom of the team section.
LinkedIn
Twitter
