Hello, I can’t find the correct solution:
Trying to apply IF with a datetime data, and select %.
Thanks Sara
BK[Booked on]will result into a list of dates. It is being compared with a single date “1.6” , hence the error.
You will need to select an expression to give a single date value in place of BK[Booked on]. May be just [Booked on] if the column Cargos % is in the same table as BK.
2 Likes
It’s not the same table, whant can I do and this data [Booked on] it’s a virtual one.
Sara
Thanks @Suvrutt_Gurjar
your ideas help me so much, I think I can find it with other data
IF([Booked on]<“01/06/2022 00:00”,“0.011”,“0.109”)
Solved. Using formula in Booked on:
Who needs a soap opera having an appsheet!!! LOVE IT!!!
2 Likes