This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’m a big fan of Airtable and am using it as a case study. I’m doing some research into how people use app templates and if offering them is worth it for most users. I’m hoping some of you lovely folks on Reddit can help me out by answering a couple ...
I have a very simple formula request that is blowing my mind right now. I don’t know why this is so difficult.
If the field {Due Date} is today, return the value “Due Today” in the formula field. First I tried:
IF({Due Date}=TODAY(),“Due Today”)
Pret...
Thanks for your help Alex, I do appreciate it, but I think I will give up on this for now. It’s getting to be a waste of time, I’ve been working on this for nearly 3 hours now.
The DATETIME_FORMAT formula failed until I realized that the apostrophes ...
Sorry, I should rephrase my comment. You’re correct, it does not allow improper syntax. However, there are times when there is no clear indication what values are correct within a formula.
In my original example above should I write ‘days’, ‘day’ or ...
It is 11:54PM EST, 6/4/19 and TODAY() returns 12:00AM 6/5/19 so no, it isn’t returning the correct date or time. Which might explain why =TODAY() isn’t working but the next question would be, why?
