Can I put a Valid_If on DateTime so that users can only choose times with certain minutes?
On this app I need to limit them to 15 minutes, so any times with 00, 15, 30, 45
The reason for this is Iโm warning about duplicate jobs for the same person. Iโm doing this with a very wide google sheet comparing every 15 minutes of every job. Itโs a pain but it works. But if anyone has a better way (if you know what I mean) that would be very welcome. Thereโs lots of calculations in the sheet, so I reckon it slows down the syncing.
AND(TRUE,IN(MINUTE([_THIS]-โ00:00:00โ),LIST(0,15,30,45))) should work.
It will works by adding time for the column,
AND(TRUE,IN(MINUTE(TIME([_THIS])-โ00:00:00โ),LIST(0,15,30,45)))
@Aleksi_Alkio Thanks That works
Youโre welcome
I added this useful expression to the Data and Time Expression article at help.appsheet.com - Date and Time Expressions
Date and Time Expressions help.appsheet.com
Thanks. Some other useful ones on there I might go back to.
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |