Hello, I'm frustrated! For nearly two hours I've been looking at Airtable documents trying to achieve what I could do in five minutes with a spreadsheet using the filter or query functions. There are a few recent posts on the same subject but each ca...
Hello, I have one table and would like to sync the primary field with the primary field in a second table. I tried this by creating a synced table, but the only bases available are the example bases. I moved my table to the example bases workspace, b...
Hello! Can anyone advise on the IF formula to state if a date has passed a number of days? So if the date in “DATE” column is more than 60 days ago, then :white_check_mark:
or :no_entry: .
I’ve been looking through date and time functions in the F...
Hello, I’m trying to get a formula working to determine age in years with one decimal place. The date is in a column called “Created”, the formula I’ve got is:
DATETIME_DIFF(TODAY(), Created,'years') & ' years'
Can anyone help add the decimal place ...
Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/...
Thanks kuovonne, I’ve had a go with automations a little before and it works well, although I can’t see how that would work for this.
I might do better to just copy and paste the specific items into a new table but I don’t know if the product should ...
Hi Justin, thanks for your help. Yes, I do mean within the same base, but it appears now that maybe Airtable isn’t suitable for this specific need. The primary field is a list of products, and I’m needing a way to organise contact with around 20 pros...
Dominik_Bosnjak:
IF(DATETIME_DIFF(NOW(),CREATED_TIME(),"days")>60,"✅","⛔️")
Thanks Dominik, this worked perfectly after changing CREATED_TIME() to the referenced column.
