What I want to do is this:
I have a time column, if a person changes info about a restaurant the time of change and the person that changes is added.
I want to make recent changes clear with the word CHANGED.
So I thought to use an If This Then That column
If DATE is within now and X days ago, then CHANGED, else empty.
How can I add dates other than TODAY in IFTTT?
I think you can add a math column to calculate how many days it has been since the change (relative to your “X”). Then:
If “days since change” is less than or equal to X then CHANGED, else empty.
1 Like
Mmm thanks, but doing math with date and time doesnt feel like an easy thing too 
I will see where I end up! Thanks.
It’s actually really, really simple…
Let’s say you want to highlight anything that’s changed in the past 7 days.
- Math column using the formula
Now-7 - If-then-else column:
– If Change Date is on or after math column, then CHANGED
And that’s it 
2 Likes
that feels doable!
Question,
If I do NOW-7 in a match column, it wants me to replace NOW with data from a column. But is shouldnt be like that, should it?
Hola!
Funny, when I read the IFTTT word here I thought: WTF… what does IFTTT service have to do with a dates logic? 
For me, IFTTT is this: https://ifttt.com and the Glide component for this kind of logic is ITE.
Have a nice weekend!
4 Likes
Ah thanks so much!
To me its different names for the same idea
All working fine now! Thanks again!
1 Like