Hi!
I’ ve encountered a possible Airtable quirk and was wondering if anyone has a hint how to work around it.
I have a Long Text Field with RTF enabled. In this field I have RTF formated text / Markdown text.
In a formula field I’m trying to search t...
Hi!
I have a base with quite a bit of Korean names in it. As the names often have a few different ways of romanization I have a field for alternative romanized spellings; {Alternative Spelling(-s)}. What complicates it further is that each romaizatio...
Hi!
I have a base for fanfic that imports data and chapters via Airtables Webclipper. Some fanfics have 100+ chapters, so my base is set up to accomodate up to 125 chapters, one per field.
After a fanfic is imported I want to tagg it for the characte...
Hi!
I have a formula that works awesomly to calculate international age (see below).
IF(
{ Birthday}=BLANK(),
' (N/A)',
IF(
{ Death}=BLANK(),
IF({ Birthday},' ('&DATETIME_DIFF(TODAY(), { Birthday}, 'years')&')'),
IF({...
Hi!
I’m one of those that like organizing and solving things, but is horrid at learning things strictly through textbooks and other textbased material. I learn best through application and therfore have a base where I try all kinds of things for the ...
Hi @Adam_TheTimeSavingCo!
Nope, not the Korean messing it up. I copied your base and added the Korean and it works just fine. But in my base it just doesn’t. If I copy straight from my base to yours, yours doesn’t work for that new record either. The...
Hi and welcome @TF_UNOC!
You’re on the right track. The issue is that DATETIME_DIFF() formula returns whole integers for any unit specifier, so simply trying to use a round up or similar won’t work.
What we can do is use the time difference in a calc...
That’s great that you found a solution.
When checking the same field for multiple values in a formula you can use a SWITCH() function instead.
This assumes you have a {Status} field and a {Name of Task} field.
You can use this right away in the prima...
Hi and welcome @Svenja_Rossig!
The formula you mentioned should work as is, but is of course dependant on how you determine a task completed or not. The mentioned formula only conciders if {Completed} has ANY value, not what that value might be. If y...