Sorry. Each competition varies with the number of gates/fences. Sometimes as low as 10. Sometime up to 30. In the sheet I screenshot there were 17 fences. But the solution needs to be the same however many fences there are so I don’t have to change i...

All columns are in a single table so no cross-table refs. In the table, what I referred to as gate column is actually called Fence.

Thanks but I’ve tried this a couple of times with Numeric digits set to 2. Numbers below 10 still come out as single digit.

Thank you. I’ve raised it with the engineers who are working on a fix. In the meantime, if it’s of interest, I’ve used 3 sets of enum drop down fields to represent HH MM & SS. When concatenated into a single duration field separated by colons this se...

Thank you for your response. I have been in touch with the support team. I suspect you are correct though in which case even if I manage to alter the offending settings on my own device, I can’t really expect users to do the same. Is there any workar...