time valid_if

AppSheet AppSheet Q&A
1

Hello,

I wanted to ask if someone could help me out. Im trying to make a valid_if statement where the time entered must be greater than the current time minus 2 hours.

This is what I currently have and it doesn’t seem to be functioning.

TIME([_THIS])>(timenow()-02:00:00)
2
  • “002:00:00”

Please read this:
The notions of TIME and DURATION and how to use in… - Google Cloud Community

1 Like