Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 28, 2018 05:22 PM
I’m looking for some help with a formula that…
calculates the difference between the number of days since a record was created and a field has initially had content entered into it.
–> 1a) If field is blank, it would calculate the number days between record created and today
If the number of days between record created and field has initially had content put into it is greater than 14 days, it returns an emoji ( :stop_sign: )
–>2a) if the number of days between a record created and a field updated is 14 days or less, it returns an emoji ( :green_heart: ).
Is this possible?
Jan 12, 2019 08:18 AM
IF(
IS_BEFORE(
TODAY(),
{Next Update}
),
“💚”,
“🔴”
)
Jan 12, 2019 08:37 AM
Thank you so much for your help!
Jan 24, 2019 12:04 AM
How would I go about modifying this one step further?
I have columns for date an invoice is made {Invoice date} and a date for last date for payment {Last date for payment}. In a new column I use the following folmula
IF(
{Invoice date}=BLANK(),
'', IF(
IS_BEFORE(
TODAY(),
{Last date for payment}
),
"☑️",
"🔴"
))
No problems so far, but I would like to include that it checks if it’s payed or not in another column called {Payment date} (datefield).
If paid I want it to return :white_check_mark: .
How would I achieve this?
Jan 24, 2019 12:08 PM
IF(
{Payment Date},
"✅",
IF(
{Invoice date}=BLANK(),
'', IF(
IS_BEFORE(
TODAY(),
{Last date for payment}
),
"☑️",
"🔴"
)))
Jan 25, 2019 02:40 AM
Thank you so much!
I swear that was the very first thing I tried, but admittingly I was a bit more tired than ideal when I tried it, so odds are I had a comma out of place or simmilar. Thank you!
Oct 28, 2019 06:38 AM
I’m attempting to use something much like this for my personal airtable base when it comes to budgeting and tracking my income/expenses. I essentially am trying to put together the formula that states "If {Last Paid Date} is within X days ago, “Current”, but if longer than X days ago, “Past Due”. I thought I had it figured out but my formulas just don’t work. Any assistance would be greatly appreciated.
Oct 28, 2019 09:24 AM
Airtable now has a field type called “last date modified”. If you create a new field with that type you can select it to watch any field, or a specific one. You can then reference that in a formula field. In this example, “LastMod” is my “Last Date Modified” field. It watches another field in my table. The formula is first looks to see if there is a date in LastMod, and if there is continues to compare to a timeframe (greater than 3 minutes) and then enters the information.
IF({LastMod},IF(DATETIME_DIFF(NOW(),{LastMod},‘minutes’)>3,“Past Due”,“Current”))
Hope this helps