# How can I structure formula for this requirement
**URL:** https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589
**Category:** Uncategorized
**Tags:** if-formula
**Created:** [March 3, 2025, 12:06pm UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589 "2025-03-03T12:06:36Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@rahulchavan](https://community.baserow.io/u/rahulchavan)
#### Post date: [March 3, 2025, 12:06pm UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/1 "2025-03-03T12:06:36Z")
I have 3 columns
names are like below
1 link
(single line text)
2 scheduled
(date with time 12hours, timezone)
3 slug
(forumula type
link and scheduled will be already filled up
with texts and dates
now I want third column to show the content from first column only when
current date and time matches with second column
how can I structure the formula,
tried but it’s giving errors
---
### Author:  [@cwinhall](https://community.baserow.io/u/cwinhall)
#### Post date: [March 4, 2025, 8:17am UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/2 "2025-03-04T08:17:23Z")
This will match if the hour is the same. Not to the minute.
However, it’s important to note that this will not update in real time in the UI. You would need to refresh in order for this formula to be executed for the current time.
```auto
IF(DATETIME_FORMAT(NOW(), 'YYYY-MM-DD HH:mm') = DATETIME_FORMAT(field('Scheduled'), 'YYYY-MM-DD HH:mm'),
field('Link'),
'')
```
---
### Author:  [@rahulchavan](https://community.baserow.io/u/rahulchavan)
#### Post date: [March 4, 2025, 10:12am UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/4 "2025-03-04T10:12:33Z")
@cwinhall thanks for understanding and making the formula.
but what happen here is if current date passes,
when scheduled date compare with NOW(some new date), older links gets disappeared.
hope you understood,
for example if your table have scheduled date 04/03/2025
if this comparision happens tomorrow, links will be automatically gone from slug.
because Scheduled Date is not equal to 05/03/2025 (tomorrow)
no problem matching with hour. I don’t want minute matching , even day matching also fine. but as we move into future date results gets reversed and links gets removed…
---
### Author:  [@cwinhall](https://community.baserow.io/u/cwinhall)
#### Post date: [March 4, 2025, 2:58pm UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/5 "2025-03-04T14:58:40Z")
I’m not sure I fully udnerstand your requirement. Can you create some example data for me how you would expect it to work exactly?
---
### Author:  [@rahulchavan](https://community.baserow.io/u/rahulchavan)
#### Post date: [March 4, 2025, 5:09pm UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/6 "2025-03-04T17:09:38Z")
Ok
I’ll send my table screenshot
---
### Author:  [@rahulchavan](https://community.baserow.io/u/rahulchavan)
#### Post date: [March 5, 2025, 7:31am UTC](https://community.baserow.io/t/how-can-i-structure-formula-for-this-requirement/9589/7 "2025-03-05T07:31:52Z")
@cwinhall
Forget the first question I aksed, here is the main requirement I have.
I am using Webstudio website builder, and Baserow as backend.
One row in Baserow table is one page content in Webstudio.
Now I will add 100 row data (100 web pages data) with CSV import.
How webstudio picks content is by looking at a specific column which we given to webstudio.
In that column we mention slug(page links)
eg1. about
eg2. contact
eg3. services
webstudio will look my links column and if it found about,
it will publish the data on that row on example. com/about
similar for other two rows content will be published on
example. com/contact and example. com/services .
now I have added 100 pages in Baserow, but I want to send 1 page everyday to webstudio.
So I thought I will add links every day with date formula, but its not working.
in future if I add 1000 blog posts, one in each row, and want to add one link every day, so webstudio will pick the link everyday and show that row content as blog post in website.
how can I schedule this in baserow?