# Function if and

**URL:** https://community.glideapps.com/t/function-if-and/82668
**Category:** Ask for Help
**Created:** [June 22, 2025, 8:11pm UTC](https://community.glideapps.com/t/function-if-and/82668 "2025-06-22T20:11:21Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Yoda64](https://avatars.discourse-cdn.com/v4/letter/y/c2a13f/32.png) [@Yoda64](https://community.glideapps.com/u/Yoda64)
#### Post date: [June 22, 2025, 8:11pm UTC](https://community.glideapps.com/t/function-if-and/82668/1 "2025-06-22T20:11:21Z")

</div>

Hi I’m stuck on an if - and condition Basically I have the column with today’s date and the column with today’s time I should make sure that if the date is today’s and the time is greater than 11 am you have to send a notification otherwise send the new row I don’t know if the if function exists and otherwise I don’t know how to get there If someone can kindly direct me Thanks

---

<div class="post-metadata">

### Author: ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)
#### Post date: [June 22, 2025, 8:45pm UTC](https://community.glideapps.com/t/function-if-and/82668/2 "2025-06-22T20:45:07Z")

</div>

Hey Yoda! Glad to see you again.  
Can you be more specific on what u meant by this:

> [@Yoda64](#):
>
> otherwise send the new row I don’t know if the if function exists

---

<div class="post-metadata">

### Author: ![Yoda64](https://avatars.discourse-cdn.com/v4/letter/y/c2a13f/32.png) [@Yoda64](https://community.glideapps.com/u/Yoda64)
#### Post date: [June 22, 2025, 9:42pm UTC](https://community.glideapps.com/t/function-if-and/82668/3 "2025-06-22T21:42:09Z")

</div>

if today’s date is in the date column and the time column is greater than 11:00 a.m. then notify me “too late” otherwise start the action

---

<div class="post-metadata">

### Author: ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)
#### Post date: [June 22, 2025, 11:11pm UTC](https://community.glideapps.com/t/function-if-and/82668/4 "2025-06-22T23:11:43Z")

</div>

To do this in Glide:

1. **Add a “Now” column** to get the current date and time.
2. **Split your date and time columns** if needed (“Date” and “Time”).
3. Create an **“If Then Else” column** with this logic:

> If Date is today **and** Time is after 11:00 AM → Send Notification  
> Else → Just send new row

You can then use this column to trigger actions like notifications or sending data.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 23, 2025, 12:32am UTC](https://community.glideapps.com/t/function-if-and/82668/5 "2025-06-23T00:32:58Z")

</div>

Is it a scheduled workflow or a user-initiated workflow?

Regardless, you can try a math column with an HOUR(Time) function. That will return a number in a 24-hour format. If it’s greater than 11, you do something, else you do something else.

The difference is scheduled workflows run server-side, and will use UTC+0 I believe.

---

<div class="post-metadata">

### Author: ![Yoda64](https://avatars.discourse-cdn.com/v4/letter/y/c2a13f/32.png) [@Yoda64](https://community.glideapps.com/u/Yoda64)
#### Post date: [June 23, 2025, 1:48pm UTC](https://community.glideapps.com/t/function-if-and/82668/6 "2025-06-23T13:48:03Z")

</div>

I used this logic but I don’t understand how to set the “if then else” column because I can’t find the way to add “and”

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 23, 2025, 1:53pm UTC](https://community.glideapps.com/t/function-if-and/82668/7 "2025-06-23T13:53:31Z")

</div>

There’s no way to add “AND” in an if-then-else column. You have to work through the logic in a bit of an unconventional way.

---

<div class="post-metadata">

### Author: ![Yoda64](https://avatars.discourse-cdn.com/v4/letter/y/c2a13f/32.png) [@Yoda64](https://community.glideapps.com/u/Yoda64)
#### Post date: [June 25, 2025, 5:37pm UTC](https://community.glideapps.com/t/function-if-and/82668/8 "2025-06-25T17:37:47Z")

</div>

I had to change my reasoning and in the end I succeeded
