LinkedIn
Twitter
Hi there,
I have two columns where drivers put km at the beginning and at the end of trip. I want to check when km are not imputed consecutively.
In Google sheet I manage to do this with conditional formatting as in pic.
I could set the initial value of km inizio with this expression Max(Calcolo costo[Km fine]) (I have this expression in Suggested value). I don't want user to be stuck here, if the previous driver has not imputed his trip or any other reason. But I would like to have the field highlighted in a view (as in the picture) just as an alert.
On one hand this means also that I need the rows properly ordered ... I'm not sure how to do this in the original spreadsheet (actually I'm moving the rows manually).
Solved
1 ACCEPTED SOLUTION
Oh my God ... it works Eureka Eureka ... i don't know why because the result of the testing of te expression looked odd to me (always yes) but then it does what I wanted ...
I put two rules
- Not(in([km inizio],list(Calcolo Costo[km fine])))
- Not(in([km fine],list(Calcolo Costo[km inizio])))
and I got the result as below!
