I’ve got a Valid_If expression to validate the length of time of a shift and make sure it’s on quarter hours =AND([_THIS] > [Start Time] ,[_THIS] <([Start Time]+(10/24)),TRUE,IN(MINUTE([_THIS]-“00:00:00”),LIST(0,15,30,45)))
It works on chrome, but not on ipad or android. I’ve tried it without the quarter hours and it still doesn’t work. Locale is set correctly, I’ve removed he expression and then saved a date to test it. Any ideas? Thanks
LinkedIn
Twitter
