I am trying to pick out the lowest time (column 2 or 3) that is TRUE in column 1.
I can use a rollup to get 15 or 120 easily.
I used an IF THEN ELSE to bring out the 2 values selected but rollup only allows count/count unique, the same is true if I “convert” the values with a Maths or a Template column.
This works with the caveat that all the boolean columns had been activated in the same way, which is very odd.
I have a custom trigger to set columns to TRUE or FALSE, if I tick or untick the Boolean in the data editor it records it as a different value.
Make of that what you will 
Try using true/false (lowercase) in your Set Columns action.
1 Like
Yup, that worked. Booleans are case sensitive.
Thank you again.