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 |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |