Help

Time in an IF formula

Topic Labels: Formulas
Solved
Jump to Solution
1323 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alba_Machado2
7 - App Architect
7 - App Architect

Hi everyone,

For the freelancing part of my making-ends-meet endeavors, I have started tracking tasks. Usually, that’s no problem with Airtable. But once in a while, I’ll forget to enter a task when I start it, and, instead, enter it when I remember to do so. That means CREATED_TIME() in the primary field gives me that later time, and that’s not helpful.

I tried to get around this by using this formula:

IF({Manual Date & Time},{Manual Date & Time},CREATED_TIME())

But if I toggle on “Use the same time zone…,” the CREATED_TIME() goes wonky. And if I don’t toggle on “Use the same time zone…,” the {Manual Date & Time} goes wonky. How can I get the time zone to be consistent in this formula field whether it’s autogenerated or manually entered?

If someone could help me figure this out, I would be really grateful!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Make sure that the “use same time zone” toggle is set the same for all fields involved, including the formula field.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Make sure that the “use same time zone” toggle is set the same for all fields involved, including the formula field.

Alba_Machado2
7 - App Architect
7 - App Architect

Jeepers, how did I miss that? My face is red but my heart is grateful. Thanks, Kuovonne!